Repeating group of specific group of numbers

[cgreaves32]

I am trying to get excel to repeat a group of numbers. Lets say that in column A is numbers 1 - 10, how do i get excel to repeat the same group 1 - 10 starting from the first blank cell.

[Ken Puls]

I'd put a 1 in cell A2, then put the following in A3 and copy down:

=IF(A2+1>10,1,A2+1)

At that point if you want it to repeat numbers 1-15, change the 10. If you want it to start at 5, change the ,1, to ,5,

Hope that helps,

[JoePublic]

Select the 10 cells then either:
1. Hold Ctrl, then click and drag the fill handle down as far as required; or
2. Right-click and drag the fill handle and choose 'Copy cells' after releasing.