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