Sep 12 2021 02:54 PM
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 |
Sep 12 2021 03:02 PM
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.
Sep 12 2021 03:08 PM
Sep 12 2021 03:18 PM
SolutionSep 12 2021 03:18 PM
Solution