Numbering in blocks on 5

  • Thread starter Thread starter Jason Excel non guru
  • Start date Start date
J

Jason Excel non guru

Hi all,
Need to number like this but up to 600!?

1
1
1
1
1
2
2
2
2
2

Any help would save my rsi....
 
Hi Jason

1. Enter the 1st set of number in A1 to A5 (ie; 1 in each cell)

2. In cell A6 enter the below formula and copy down as required.
=A1+1


If this post helps click Yes
 
Hi

Try this macro:

Sub FillBlock()
off = 0
For r = 1 To 600
For b = 1 To 5
Range("A" & 1 + off) = r
off = off + 1
Next
Next
End Sub

Regards,
Per

"Jason Excel non guru" <Jason Excel non (e-mail address removed)>
skrev i meddelelsen
news:[email protected]...
 
Enter this formula in A1 and fill it down as necessary:
=INT((ROW()-1)/5)+1

Regards,
Stefi


„Jason Excel non guru†ezt írta:
 
Another way is to use the below formula and copy down as required.

=INT((ROW(A1)-1)/5)+1

If this post helps click Yes
 
Back
Top