Linera fill formula
 

I have data in columns A and B, as follows:

C00010 C00015
T02030 T02035

In column C, I want to create an incremental Fill series formula (i.e. not
using the Fill handle method) so that the result looks like this:

C00010
C00011
C00012
C00013
C00014
C00015
T02030
T02031
T02032
T02033
T02034
T02035

Ive tried the toolbar route of Edit\Fill\Series\ Type €“Linear\ Step Value
1\Stop Value, but having the letter in front of the numeric part of the data
seems to stop it performing. Any suggestions will be gratefully received.

--
Geoff

Linera fill formula
 

Geoffric wrote:
I have data in columns A and B, as follows:

C00010 C00015
T02030 T02035

In column C, I want to create an incremental Fill series formula (i.e. not
using the Fill handle method) so that the result looks like this:

C00010
C00011
C00012
C00013
C00014
C00015
T02030
T02031
T02032
T02033
T02034
T02035

Ive tried the toolbar route of Edit\Fill\Series\ Type €“Linear\ Step Value
1\Stop Value, but having the letter in front of the numeric part of the data
seems to stop it performing. Any suggestions will be gratefully received.


Here's an outrageous kludge. It works, but uses umpteen helper columns
and doesn't generalize well... have fun.

Assuming your "A" and "B" data are in $A$1:$B$2, put the following in
the specified columns of row 1 and fill down:

C: =IF(N1,L1&TEXT(M1,"00000"),"")
D: =LEFT($A$1,1)
E: =VALUE(MID($A$1,2,5))
F: =VALUE(MID($B$1,2,5))
G: =LEFT($A$2,1)
H: =VALUE(MID($A$2,2,5))
I: =VALUE(MID($B$2,2,5))
J: =E1+ROW()-1
K: =H1+ROW()-(F1-E1+1)-1
L: =IF(J1<=F1,D1,G1)
M: =IF(L1=D1,J1,K1)
N: =OR(L1=D1,AND(L1=G1,K1<=I1))