How do I create an auto prioritized table ?

Is it possible to create an auto priority column in a table list? Initially, I have a priority list column in one of my lists that have the users changing the priority of an item based on its importance.  This can be changed whenever the priority of an item changes. I was envisioning a data validation list. So, for example, I have a drop down that allows the users to select a number ie. (1 – 100).  If they select 1 its an high importance, etc. If say for example that priority changes and the user changes it from 1 to 5, then Items will shift up a priority. So the row with priority 2 will move to 1, 3 to 2, 4 to 3, 5 to 4? Ideally, the rows of the table will rearrange based on the new priority, but if that requires code; otherwise I can manually resort later.

Explorer Asked on 19th March 2017 in Excel for Windows.
Add Comment
  • 1 Answer(s)
    Enthusiast Answered on 1st July 2017.
    Add Comment
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of use.