View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scott Hemphill Scott Hemphill is offline
external usenet poster
 
Posts: 6
Default Sequential Numbers

I have a worksheet where i want to number a column sequentially but not every
row. I put number 1 in column A1 and then put the formula A1+1 and copy it
down, sometimes i have blank rows where i don't need any numbers, sometimes i
delete and add rows. Is there a way without just copy and paste to achieve
the same results?
--
Scott Hemphill