| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternating Fill Series
Could you please help me. I am trying to alternate numbers IE: 400001,
400251, 400002,400252, 4000032, 400253 etc. Need a total of 1000 records. How can I make the fill series work with this? PaulaB |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Alternating Fill Series
400001
400251 =A1+1 =a2+1 select cells A3 and 4 and drag down. paulab wrote: Could you please help me. I am trying to alternate numbers IE: 400001, 400251, 400002,400252, 4000032, 400253 etc. Need a total of 1000 records. How can I make the fill series work with this? PaulaB |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Alternating Fill Series
Do I need to format my cells? I get 400002, 400252 repeated down to cell
1000 when I enter the =A1+1 =A2+1 They do not increment "Bob I" wrote: 400001 400251 =A1+1 =a2+1 select cells A3 and 4 and drag down. paulab wrote: Could you please help me. I am trying to alternate numbers IE: 400001, 400251, 400002,400252, 4000032, 400253 etc. Need a total of 1000 records. How can I make the fill series work with this? PaulaB . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Alternating Fill Series
What happens when you copy down?
Make sure you're in automatic calculation mode. In xl2003 menus: tools|options|calculation tab paulab wrote: Do I need to format my cells? I get 400002, 400252 repeated down to cell 1000 when I enter the =A1+1 =A2+1 They do not increment "Bob I" wrote: 400001 400251 =A1+1 =a2+1 select cells A3 and 4 and drag down. paulab wrote: Could you please help me. I am trying to alternate numbers IE: 400001, 400251, 400002,400252, 4000032, 400253 etc. Need a total of 1000 records. How can I make the fill series work with this? PaulaB . -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Alternating Fill Series
General, are you dragging down with the fill series handle?
paulab wrote: Do I need to format my cells? I get 400002, 400252 repeated down to cell 1000 when I enter the =A1+1 =A2+1 They do not increment "Bob I" wrote: 400001 400251 =A1+1 =a2+1 select cells A3 and 4 and drag down. paulab wrote: Could you please help me. I am trying to alternate numbers IE: 400001, 400251, 400002,400252, 4000032, 400253 etc. Need a total of 1000 records. How can I make the fill series work with this? PaulaB . |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Alternating Fill Series
Thanks Dave,
I did have to turn on Formula calculation options to automatic in Excel2007. "Dave Peterson" wrote: What happens when you copy down? Make sure you're in automatic calculation mode. In xl2003 menus: tools|options|calculation tab paulab wrote: Do I need to format my cells? I get 400002, 400252 repeated down to cell 1000 when I enter the =A1+1 =A2+1 They do not increment "Bob I" wrote: 400001 400251 =A1+1 =a2+1 select cells A3 and 4 and drag down. paulab wrote: Could you please help me. I am trying to alternate numbers IE: 400001, 400251, 400002,400252, 4000032, 400253 etc. Need a total of 1000 records. How can I make the fill series work with this? PaulaB . -- Dave Peterson . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Series | Excel Worksheet Functions | |||
| Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
| fill rows with alternating data ? | Excel Discussion (Misc queries) | |||
| Edit Fill Series - How do I fill using minute increments | Excel Discussion (Misc queries) | |||
| Fill Series | New Users to Excel | |||
Linear Mode
