I use an excel spreadsheet to prioritise tasks during my work day.

Sometimes I change the priority of my tasks (I have a separate column for
the priority number).

As it stands, whenever I change a number, e.g. priority 2 to priority 4 - I
have to then go and re-number every other task on my list.

Is there a way of automatically changing the numbers so that I don't have to
manually do this?

If there is a formula you could give me, that would be fantastic. Thanks so
much!