Set the serial number every 15th column
 

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

In A1 and then copy down

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

Copy Col A and paste special as values.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"SJ" wrote in message
...
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

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

-----Original Message-----
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


.