View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default 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