Repeat row numbers

  • Thread starter Thread starter Carole O
  • Start date Start date
C

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
 
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
 
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
 
Back
Top