Renumber and Resequence into Whole Numbers

[BrooksTech]

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.

 

[earthworm]

are you talking about numbering rows or column ?

 

[BrooksTech]

are you talking about numbering rows or column ?

rows

e.g.

1
3
4
2
3.5

And BTW, I cannot use formulas during number entry e.g. "A2+1" etc. on down cus theyre entered STATIC and out of their original sequence. Again, when finished entering they need to be resorted and renumbered into whole numbers.

 

[NiMip]

You could have the RANK formula in another column, and applied to the column you're manually entering the numbers into. That should give you the whole numbers you seek and if you wanted to clean it up, you just copy the RANK results and paste as values over the manual-entry column.

 

[BrooksTech]

Well thank you but I'll have to check a Youtube or something on how the RANK function is used.

But to further clarify, I dont want to manually insert 14.5 for example. Just type it in the last row, sort, then its somehow automatically renumbered to 15. And that last part Ive never seen Excel do, but it should be possible somehow.

Thanks again.