Need help with a formula that is automically adjusting numbers if any of them is deleted.

[Lethol]

Let us say that I am updating the list by removing number 3 and 5. Bear in mind that the original list is 1 - 450. It would be a hassle to update the list manually.
After the mentioned numbers have been deleted I want the column top change so it looks like the right column. I all want the following numbers to
adjust automatically. Is there a formula that can do that Excel 2016?

[B]Before deleting number 3 and 5[/B]    [B]After deleting 3 and 5, I want to column to change like this:[/B]
1    war.esp                      1 war.esp                                      
2    blueBow.esp                  2 Merging blueBow.esp with                  
3    yellowBow.esp                  yellowBow.esp
4    blackSword.esp               3 Merging blacksword.esp with                                                                               
5    greenSword.esp                 greenSword.esp                                             
6    pinkAxe.esp                  4 pinkAxe.esp                                        
7    blackAxe.esxp                5 blackAxe.esp

This is a list of plugins for Skyrim. Some plugins will be merged and along the way the numbers of active plugins will be reduced from 450 to 255...
I want to keep track of active plugins and how many merges I have to do, by automatically adjust the numbers in excel. Sometime I may be able
to merge 10 plugins, another time 4 and I need the list to update accordingly.

 

[Ron Coderre]

Not sure if I have enough details....but...
With your sample list in B2:B8
This formula, copied down, maintains an incremental count , even if rows are deleted (but not added)

A2: =MAX(A$1:A1)+1

Is that something you can work with?