Repeat row numbers

[Carole O]

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

 

[Fred Smith]

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

Regards,
Fred

 

[מיכ×ל (מיקי) ×בידן]

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]

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

 

[Carole O]

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

Thanks for your help!

Carole O