Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Contiguous Line Count
You could use
=row() Which will return the row number that the formula is in. When you insert a new row and the other rows shift down they will re-number themselves. You will then just need to copy the formula down one row to fill the appropriate cell in the blank row just added... -- HTH... Jim Thomlinson "tommcbrny" wrote: Hello, I have a list in MS Excel where column A is the priority for the item described in th row. Periodically, new items come up that are higher in priority than some or all other items in the list. Can I number column A so that all priority numbers adjust automatically when lines are inserted (or deleted). For instance, I have items 1-10 existing. I insert a new item between current items 3 and 4. The new item should become item 4, with all following items incrementing by 1 (old 4 becomes 5, 5 becomes 6, etc). Thanks, Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a limit line | Charts and Charting in Excel | |||
Combination chart - Line - Column on 2 Axes | Charts and Charting in Excel | |||
HOW TO COLOR ACTIVE LINE CURSOR IS ON WHEN MOVING | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |