SOLVED

Automatically update number value?

%3CLINGO-SUB%20id%3D%22lingo-sub-2744340%22%20slang%3D%22en-US%22%3EAutomatically%20update%20number%20value%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2744340%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20formula%20I%20can%20use%20to%20update%20remaining%20numbers%20If%20I%20remove%20a%20number%20from%20a%20column%3F%3CBR%20%2F%3EI%20have%20the%20column%20below%20in%20a%20chart%20a%20I%20made.%20I%20would%20like%20all%20the%20numbers%20to%20update%20if%20I%20remove%20a%20number.%3C%2FP%3E%3CP%3EExample%3A%20If%20I%20remove%20the%20number%201%20or%205%2C%20so%20it%20makes%20the%207%20a%206%2C%20the%2022%20a%2021%2C%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20pretty%20much%20a%20novice%2C%20but%20I%20want%20to%20do%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%2256%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2256%22%20height%3D%2235%22%3E1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E4%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E6%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E7%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E8%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E9%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E10%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E12%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E13%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E11%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E14%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E19%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E26%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E18%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E20%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E17%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E29%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E15%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E30%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E16%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E27%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E28%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E21%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E22%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E24%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2235%22%3E31%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2744340%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2744360%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20update%20number%20value%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2744360%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1153626%22%20target%3D%22_blank%22%3E%40Kim_Kline%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsually%20a%20good%20practice%20is%20keep%20your%20numbers%20sorted.%3C%2FP%3E%3CP%3EDo%20you%20want%20to%20replace%20the%20%22removed%22%20number%20by%20the%20highest%20%2B%201%20from%20the%20list%3F%3C%2FP%3E%3CP%3ESorry%2C%20but%26nbsp%3BI%20really%20didnt%20get%20what%20you%20mean.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2744364%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20update%20number%20value%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2744364%22%20slang%3D%22en-US%22%3EI'm%20sorry%20I'm%20having%20trouble%20explaining.%3CBR%20%2F%3EThis%20is%20a%20chart%20I%20am%20using%20to%20address%20all%20debt.%20These%20numbers%20are%20the%20order%20I%20want%20to%20pay%20them.%20I%20have%20the%20bills%20categorized%20which%20is%20why%20they%20are%20not%20in%20numerical%20order%20in%20this%20column.%20After%20I%20pay%20off%20number%20one%2C%20I%20want%20to%20delete%20that%20number%20so%20that%20number%202%20becomes%20number%201%2C%20and%20so%20on.%3CBR%20%2F%3EDoes%20that%20help%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2744367%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20update%20number%20value%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2744367%22%20slang%3D%22en-US%22%3EUnderstood%3CBR%20%2F%3EWell%2C%20I%20would%20suggest%20you%20a%20different%20approach%2C%20that%20is%20common%20use%20for%20case%20like%20yours.%3CBR%20%2F%3EYou%20use%20an%20auxiliary%20column%20where%20you%20can%20%22flag%22%20it%20as%20paid%20on%20unpaid.%3CBR%20%2F%3EThis%20practice%20is%20used%20because%20its%20easier%20to%20track%20what%20is%20pending%20and%20also%20when%20that%20information%20was%20updated.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2744372%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20update%20number%20value%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2744372%22%20slang%3D%22en-US%22%3EThank%20you!%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

Is there a formula I can use to update remaining numbers If I remove a number from a column?
I have the column below in a chart a I made. I would like all the numbers to update if I remove a number.

Example: If I remove the number 1 or 5, so it makes the 7 a 6, the 22 a 21, etc. 

I'm pretty much a novice, but I want to do this.

 

Thank you in advance!

 

1
2
3
4
5
6
7
8
9
10
12
13
 
 
11
14
19
25
26
 
 
18
20
17
29
15
30
16
27
28
21
23
22
24
 
31
4 Replies

@Kim_Kline 

 

Usually a good practice is keep your numbers sorted.

Do you want to replace the "removed" number by the highest + 1 from the list?

Sorry, but I really didnt get what you mean.

I'm sorry I'm having trouble explaining.
This is a chart I am using to address all debt. These numbers are the order I want to pay them. I have the bills categorized which is why they are not in numerical order in this column. After I pay off number one, I want to delete that number so that number 2 becomes number 1, and so on.
Does that help?
best response confirmed by allyreckerman (Microsoft)
Solution
Understood
Well, I would suggest you a different approach, that is common use for case like yours.
You use an auxiliary column where you can "flag" it as paid on unpaid.
This practice is used because its easier to track what is pending and also when that information was updated.
Thank you!