Repeating group of specific group of numbers

cgreaves32

New member
Joined
Sep 9, 2011
Messages
1
Reaction score
0
Points
0
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.
 
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,
 
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.
 
Back
Top