Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula fill down | Excel Discussion (Misc queries) | |||
fill column with formula | Excel Worksheet Functions | |||
Formula Fill help | Excel Worksheet Functions | |||
Fill Down formula Help Please | Excel Discussion (Misc queries) | |||
Help with formula fill down | Excel Discussion (Misc queries) |