Numbering in blocks on 5

  • Thread starter Jason Excel non guru
  • 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....
 
J

Jacob Skaria

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
 
S

Stefi

Enter this formula in A1 and fill it down as necessary:
=INT((ROW()-1)/5)+1

Regards,
Stefi


„Jason Excel non guru†ezt írta:
 
J

Jacob Skaria

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
 
Top