+ Reply to Thread
Results 1 to 2 of 2

Custom Series fill format

  1. 04-16-2017, 02:00 AM #1
    green369
    green369 is offline
    Registered User
    Join Date
    12-19-2012
    Location
    india
    MS-Off Ver
    MS 365
    Posts
    31

    Smile Custom Series fill format

    Hi

    Friends

    i have a problem i i want to fill series in column as in the attached file in column "D" i have created a custom format as "RK2:"00"->" but the remaining series i cant understand how to do, the alphabets should come from A to H and should continue again from A to H after the alphabet number shouls come 01 to 12 that is from A to H as A01,B01,C01,D01,E01,F01,G01,H01 and again the series should start with A02,B02,C02,D02,E02,F02,G02,H02, this should continue up to A12,B12,C12,D12,E12,F12,G12,H12. after that @ symbol number 1 to 4 should come for four cells . PLease kindly help me to get the out as this example text


    RK2:05->E01@3


    Thanking You
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-16-2017, 03:26 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Custom Series fill format

    This is rather confusing. Do you REALLY want the last digits to appear in the order (each in 4 replicates): 4, 3, 1, 2 (that is what you asked for...)??

    If so, this formula, pasted into a sheet and copied down, does that:

    ="RK2:"&TEXT(ROWS($1:1),"00")&"->"&CHAR(65+MOD(ROWS($1:1)-1,8))&TEXT(1+INT((ROWS($1:1)-1)/8),"00")&"@"&LOOKUP(INT((ROWS($1:1)-1)/4),{0,1,2,3},{4,3,1,2})
    Attached Files Attached Files
    Last edited by Glenn Kennedy; 04-16-2017 at 03:44 AM.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Custom Drag Fill Series possibility??
    By Mr_Ekid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2016, 04:30 PM
  2. Custom fill series
    By 2013 in forum Excel General
    Replies: 2
    Last Post: 11-20-2013, 02:10 PM
  3. Custom Numerical Fill Series
    By sabrinigreen in forum Excel General
    Replies: 7
    Last Post: 12-21-2011, 10:50 PM
  4. Excel 2007 : Custom Series using the drag to fill handle
    By bellman in forum Excel General
    Replies: 1
    Last Post: 07-06-2010, 06:06 PM
  5. [SOLVED] Custom fill series?
    By martinkorner in forum Excel General
    Replies: 15
    Last Post: 06-25-2006, 01:30 PM
  6. Help with Excel Fill Custom Series
    By CADDMiami in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 03-16-2005, 10:41 PM
  7. I've created a custom fill series. Now I don't know how to use i.
    By candybluevt in forum Excel General
    Replies: 2
    Last Post: 01-26-2005, 05:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1