Automatic Numbering
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!
|