Thread: item numbers in a list that update if a row is deleted
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
  
Posts: 427
Default item numbers in a list that update if a row is deleted
Instead of the formula =previous cell + 1, how about =ROW() . This
returns the row number on which the formula is entered if the () is
blank, or the row number of a reference, as in =ROW(A2), which returns
2.

Reply With QuoteReply With Quote