Ranked list
I would like to automatically rank the records in a query of numbers, so that the highest one is 1, the next lower one is 2, etc.
However, where there are two numbers the same, they should have the same rank and the next entry would then compensate for all of those records with the same rank.
Ie. In the sample file attached, it would look like this"
Rank Quantity
1 391
2 390
2 390
4 385 (this record is #4 because there are 3 records above it.)
etc.
Is there an easy way to do this?