BrooksTech
Board Regular
- Joined
- May 9, 2011
- Messages
- 59
Not ever seen this done yet but it needs to be added into Excel Functionality if it does not already exist:
I have a sequence of numbers in a column "Priority," but at the end I discovered I had NEW items to insert at various places in the list. Normally I'd have to go through and manually renumber all of the affected items. Sometimes this would be necessary 5 or 6 times or more, plus if its a really long list becomes a small nightmare.
What I'd prefer to happen is add new items at end, and number them in the desired insertion point, so if i want something inserted between 14 and 15, the added row would be numbered 14.5, accordingly with many other late entries. Re-SORT them, then the needed part: Have them all automatically renumbered, meaning 14.5 gets renumbered to 15, and the original 15 to 16, etc on down the rows.
I go through this so often and believe enough others do, to need to automate this otherwise manual task.
I have a sequence of numbers in a column "Priority," but at the end I discovered I had NEW items to insert at various places in the list. Normally I'd have to go through and manually renumber all of the affected items. Sometimes this would be necessary 5 or 6 times or more, plus if its a really long list becomes a small nightmare.
What I'd prefer to happen is add new items at end, and number them in the desired insertion point, so if i want something inserted between 14 and 15, the added row would be numbered 14.5, accordingly with many other late entries. Re-SORT them, then the needed part: Have them all automatically renumbered, meaning 14.5 gets renumbered to 15, and the original 15 to 16, etc on down the rows.
I go through this so often and believe enough others do, to need to automate this otherwise manual task.