Lee B.

I have a technical Excel question: When I rank a match, I assign it a number, and then I have to manually change the number of every match ranked lower than that. Changing all those numbers is tedious and takes a lot of time. Is there a trick in Excel that automatically reorders the matches when you insert a new number that creates a "duplicate" for an already existing number? Thanks, Lee