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?