Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
item numbers in a list that update if a row is deleted
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
item numbers in a list that update if a row is deleted
Cheers dave, this works fine.
"Dave O" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto updating list | Excel Worksheet Functions | |||
find sum in list of of numbers | Excel Discussion (Misc queries) | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
Extract each item in the list | Excel Worksheet Functions | |||
How select an item in a list box | Excel Worksheet Functions |