Repeat row numbers
 

Excel 2003
I need to number rows on a large spreadsheet from 1 - 27, and repeat 1 - 27,
etc to the end. I'd rather not copy and paste!

TIA

Carole O

Repeat row numbers
 

Put 1 in a1, and this formula in A2, and copy down:
=if(a1=27,1,a1+1)

Regards,
Fred

"Carole O" wrote in message
...
Excel 2003
I need to number rows on a large spreadsheet from 1 - 27, and repeat 1 -
27,
etc to the end. I'd rather not copy and paste!

TIA

Carole O

Repeat row numbers
 

In A1 type: =MOD(ROW()-1,27)+1 and copy down.
This will enable deletion of row(s) without producing an Error.
Micky


"Carole O" wrote:

Excel 2003
I need to number rows on a large spreadsheet from 1 - 27, and repeat 1 - 27,
etc to the end. I'd rather not copy and paste!

TIA

Carole O

Repeat row numbers
 

Micky - I copied and pasted the formula, but when I copy down, all I get is
1's all the way down. I like your idea of being able to delete rows without
producing an error. Is there a fix?

Carole O

"מיכאל (מיקי) אבידן" wrote:

In A1 type: =MOD(ROW()-1,27)+1 and copy down.
This will enable deletion of row(s) without producing an Error.
Micky


"Carole O" wrote:

Excel 2003
I need to number rows on a large spreadsheet from 1 - 27, and repeat 1 - 27,
etc to the end. I'd rather not copy and paste!

TIA

Carole O

Repeat row numbers
 

Sorry, Micky - my goof! I had manual formula set.

Thanks for your help!

Carole O

"מיכאל (מיקי) אבידן" wrote:

In A1 type: =MOD(ROW()-1,27)+1 and copy down.
This will enable deletion of row(s) without producing an Error.
Micky


"Carole O" wrote:

Excel 2003
I need to number rows on a large spreadsheet from 1 - 27, and repeat 1 - 27,
etc to the end. I'd rather not copy and paste!

TIA

Carole O