I have a spreadsheet where column c is for a Priority. We want to put a number in there to represent the priority order that this item will be worked on. We want to number them such as 1, 2, 3, 4....20. However, if I want to change the number of one of these items, I would like it to automatically re-sort the rows according to this new number. I also do not want any duplicates, so I am unsure how to do this.
Any help would be awesome!!