Hello all, I have a “to do” list on a spreadsheet. I have added a priority to each item. However, sometimes priorities change…
I would like to know what formula/method I might need to use to rearrange items should I change the priority of one such item.
I have attached an example list:
If I were to change the priority of the event Visit aunty Polly to priority 1, how could I set up the list to automatically place it at the top of the list, and re-order and adjust everything so that the items are shown in order of priority and the priority numbers are correct?
As always, many thanks in advance