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
|