Home |
Search |
Today's Posts |
#1
|
|||
|
|||
auto fill sequancial data
How can I setup, auto fill of data in Excel. For Eg: I want to start from
AAAAA and finisz with ZZZZZ, and let the program generate, everything in between, but in sequance. AAAAA, AAAAB, AAAAC, AAAAD etc.etc. |
#2
|
|||
|
|||
Not sure if this is the sequence you're looking for, but
put AAAAA into cell A1, then put this in A2 and fill down to row 129: =IF(ROW()104,CHAR(CODE(LEFT(A1))+1),LEFT(A1))&IF( (ROW() 78)*(ROW()<104),CHAR(CODE(MID(A1,2,1))+1),MID(A1, 2,1))&IF ((ROW()52)*(ROW()<78),CHAR(CODE(MID(A1,3,1))+1),M ID (A1,3,1))&IF((ROW()26)*(ROW()<52),CHAR(CODE(MID(A 1,4,1)) +1),MID(A1,4,1))&IF(ROW()<=26,CHAR(CODE(RIGHT(A1)) +1),RIGHT(A1)) HTH Jason Atlanta, GA -----Original Message----- How can I setup, auto fill of data in Excel. For Eg: I want to start from AAAAA and finisz with ZZZZZ, and let the program generate, everything in between, but in sequance. AAAAA, AAAAB, AAAAC, AAAAD etc.etc. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto fill option box disappeared | Excel Worksheet Functions | |||
Auto fill box | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
Auto Fill Options | Excel Discussion (Misc queries) |