Hi all,
I have a list of items with a priority order with 1 being the highest priority. Sometimes, the priority will change and 1 will become 3.
Is there a way to auto renumber the cells so that when a priority changes (for example: #1 becomes #3 ), the list will automatically shift and readjust the priorities so that when I manually change #1 to #3 , #2 becomes 1 and #3 becomes 2 ?
I've seen an older thread with a similar problem but there wasn't any solutions.
Thanks in advance for the help.
<tbody>
</tbody>
I have a list of items with a priority order with 1 being the highest priority. Sometimes, the priority will change and 1 will become 3.
Is there a way to auto renumber the cells so that when a priority changes (for example: #1 becomes #3 ), the list will automatically shift and readjust the priorities so that when I manually change #1 to #3 , #2 becomes 1 and #3 becomes 2 ?
I've seen an older thread with a similar problem but there wasn't any solutions.
Thanks in advance for the help.
Order/priority | Items | Price |
1 | A | 100 |
2 | B | 50 |
3 | C | 35 |
4 | D | 30 |
5 | E | 65 |
6 | F | 10 |
<tbody>
</tbody>