title: Dynamically re-order numbered list in Excel
body: <p>In Excel, is there a way to dynamically update the priority for a list of tasks? For example, if you have a column with priorities 1, 5, 3, 2, 4 and a user added a new row with a new task and assigns it a priority of 1, the list is updated with 2, 6, 4, 3, 5, 1?</p>
  
  <p>Or is there some other (better?) way of doing this? I'd rather not have to sort the list and then manually change the numbering every time a new task is added or removed. Plus, I don't think the people who will use the spreadsheet will do that.</p>