Discussion Automatically update number value? in Excel
https://techcommunity.microsoft.com/t5/excel/automatically-update-number-value/m-p/2744340#M113653
<P>Is there a formula I can use to update remaining numbers If I remove a number from a column?<BR />I have the column below in a chart a I made. I would like all the numbers to update if I remove a number.</P><P>Example: If I remove the number 1 or 5, so it makes the 7 a 6, the 22 a 21, etc. </P><P>I'm pretty much a novice, but I want to do this.</P><P> </P><P>Thank you in advance!</P><P> </P><TABLE border="0" width="56" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="56" height="35">1</TD></TR><TR><TD height="35">2</TD></TR><TR><TD height="35">3</TD></TR><TR><TD height="35">4</TD></TR><TR><TD height="35">5</TD></TR><TR><TD height="35">6</TD></TR><TR><TD height="35">7</TD></TR><TR><TD height="35">8</TD></TR><TR><TD height="35">9</TD></TR><TR><TD height="35">10</TD></TR><TR><TD height="35">12</TD></TR><TR><TD height="35">13</TD></TR><TR><TD height="35"> </TD></TR><TR><TD height="35"> </TD></TR><TR><TD height="35">11</TD></TR><TR><TD height="35">14</TD></TR><TR><TD height="35">19</TD></TR><TR><TD height="35">25</TD></TR><TR><TD height="35">26</TD></TR><TR><TD height="35"> </TD></TR><TR><TD height="35"> </TD></TR><TR><TD height="35">18</TD></TR><TR><TD height="35">20</TD></TR><TR><TD height="35">17</TD></TR><TR><TD height="35">29</TD></TR><TR><TD height="35">15</TD></TR><TR><TD height="35">30</TD></TR><TR><TD height="35">16</TD></TR><TR><TD height="35">27</TD></TR><TR><TD height="35">28</TD></TR><TR><TD height="35">21</TD></TR><TR><TD height="35">23</TD></TR><TR><TD height="35">22</TD></TR><TR><TD height="35">24</TD></TR><TR><TD height="35"> </TD></TR><TR><TD height="35">31</TD></TR></TBODY></TABLE>Sun, 12 Sep 2021 21:54:15 GMTKim_Kline2021-09-12T21:54:15ZAutomatically update number value?
https://techcommunity.microsoft.com/t5/excel/automatically-update-number-value/m-p/2744340#M113653
<P>Is there a formula I can use to update remaining numbers If I remove a number from a column?<BR />I have the column below in a chart a I made. I would like all the numbers to update if I remove a number.</P><P>Example: If I remove the number 1 or 5, so it makes the 7 a 6, the 22 a 21, etc. </P><P>I'm pretty much a novice, but I want to do this.</P><P> </P><P>Thank you in advance!</P><P> </P><TABLE border="0" width="56" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="56" height="35">1</TD></TR><TR><TD height="35">2</TD></TR><TR><TD height="35">3</TD></TR><TR><TD height="35">4</TD></TR><TR><TD height="35">5</TD></TR><TR><TD height="35">6</TD></TR><TR><TD height="35">7</TD></TR><TR><TD height="35">8</TD></TR><TR><TD height="35">9</TD></TR><TR><TD height="35">10</TD></TR><TR><TD height="35">12</TD></TR><TR><TD height="35">13</TD></TR><TR><TD height="35"> </TD></TR><TR><TD height="35"> </TD></TR><TR><TD height="35">11</TD></TR><TR><TD height="35">14</TD></TR><TR><TD height="35">19</TD></TR><TR><TD height="35">25</TD></TR><TR><TD height="35">26</TD></TR><TR><TD height="35"> </TD></TR><TR><TD height="35"> </TD></TR><TR><TD height="35">18</TD></TR><TR><TD height="35">20</TD></TR><TR><TD height="35">17</TD></TR><TR><TD height="35">29</TD></TR><TR><TD height="35">15</TD></TR><TR><TD height="35">30</TD></TR><TR><TD height="35">16</TD></TR><TR><TD height="35">27</TD></TR><TR><TD height="35">28</TD></TR><TR><TD height="35">21</TD></TR><TR><TD height="35">23</TD></TR><TR><TD height="35">22</TD></TR><TR><TD height="35">24</TD></TR><TR><TD height="35"> </TD></TR><TR><TD height="35">31</TD></TR></TBODY></TABLE>Sun, 12 Sep 2021 21:54:15 GMThttps://techcommunity.microsoft.com/t5/excel/automatically-update-number-value/m-p/2744340#M113653Kim_Kline2021-09-12T21:54:15ZRe: Automatically update number value?
https://techcommunity.microsoft.com/t5/excel/automatically-update-number-value/m-p/2744360#M113654
<P><LI-USER uid="1153626"></LI-USER> </P><P> </P><P>Usually a good practice is keep your numbers sorted.</P><P>Do you want to replace the "removed" number by the highest + 1 from the list?</P><P>Sorry, but I really didnt get what you mean.</P>Sun, 12 Sep 2021 22:02:14 GMThttps://techcommunity.microsoft.com/t5/excel/automatically-update-number-value/m-p/2744360#M113654Juliano-Petrukio2021-09-12T22:02:14ZRe: Automatically update number value?
https://techcommunity.microsoft.com/t5/excel/automatically-update-number-value/m-p/2744364#M113655
I'm sorry I'm having trouble explaining.<BR />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.<BR />Does that help?Sun, 12 Sep 2021 22:08:21 GMThttps://techcommunity.microsoft.com/t5/excel/automatically-update-number-value/m-p/2744364#M113655Kim_Kline2021-09-12T22:08:21ZRe: Automatically update number value?
https://techcommunity.microsoft.com/t5/excel/automatically-update-number-value/m-p/2744367#M113656
Understood<BR />Well, I would suggest you a different approach, that is common use for case like yours.<BR />You use an auxiliary column where you can "flag" it as paid on unpaid.<BR />This practice is used because its easier to track what is pending and also when that information was updated.Sun, 12 Sep 2021 22:18:57 GMThttps://techcommunity.microsoft.com/t5/excel/automatically-update-number-value/m-p/2744367#M113656Juliano-Petrukio2021-09-12T22:18:57ZRe: Automatically update number value?
https://techcommunity.microsoft.com/t5/excel/automatically-update-number-value/m-p/2744372#M113657
Thank you!<BR />Sun, 12 Sep 2021 22:30:50 GMThttps://techcommunity.microsoft.com/t5/excel/automatically-update-number-value/m-p/2744372#M113657Kim_Kline2021-09-12T22:30:50Z