item numbers in a list that update if a row is deleted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of data, in the left column I have an item number for each row.
If I remove a row I need the item number to update. At present if I remove
row 4 then the item no. column will read 1,2,3,5,6,7 (and miss out 4), but i
need the item no. column to read 1,2,3,4,5,6. It would be useful if I could
have the first row as row 1 (as this will not be deleted) and have a formula
in each item no. cell that calculates 'the value in the cell above +1'. Does
anybody now of how to create a formula like this?
 
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.
 
Back
Top