View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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