Inputting number range

[404'ed]

Hey,

Is there a way to have Excel fill in the first column on a sheet with a number range 3000-5000 while repeating the number as follows: 3000, 3000, 3001, 3001, 3002, 3002 ... A1 being 3000, A2 being 3000, A3 being 3001, A4 being 3001, A5 being 3002 etc... ?

Thank you so much.

[jeffreybrown]

Hello & welcome to the forum,

In A1 and A2 you could put 3000

Then in A3 >> =A1+1
Then in A4 >> = A3

Now highlight A3 and A4 then drag down

[404'ed]

Thank you so much! Worked like a charm