Set the serial number every 15th column

S

SJ

Hi All.

I would like to set the serial number every 15th column.
For example,

A B C ..................
1
2
3
..
..
15 1
..
..
30 2
..
..
45 3


Is there any formula for A column?


Thanks in advance
SJ
 
K

Ken Wright

In A1 and then copy down

=IF(MOD(ROW(),15)<>0,"",ROW()/15)

Copy Col A and paste special as values.
 
J

Jason Morin

1. Type 1 into cell A15.
2. Select A1:A15.
3. Click on the fill handle, hold the left mouse button,
and fill down as far as needed.

HTH
Jason
Atlanta, GA
 
Top