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
|