Have you ever tried using the ‘RANK’ formula with a VLOOKUP?
Most businesses generate periodic ‘league table’ reports ie reports that rank products, salesman etc in order of performance. By using the ‘RANK’ formula in conjunction with a VLOOKUP you can create a ‘League Table’ that automatically updates itself without the need to manually sort.
The example below hopefully shows this using basic data. Obviously this becomes more useful when dealing with large quantities of data.
Please feel free to download the example above. I hope you find this post useful.