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.
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,520
Reaction score
5
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
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

Super Moderator
Staff member
Joined
Sep 16, 2011
Messages
220
Reaction score
0
Points
16
Location
UK
Excel Version(s)
2016
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.
 
Top