Explanation
you might use the RANK function to rank numeric values.
RANK can rank values from largest to smallest (i.e.
top sales) as well as smallest to largest (i.e.
Related videos
How to rank values with the RANK function
Rank function example
To rank a set of numeric values, where the highest value is ranked #1, you can use the RANK function. In the example shown, the formula in D6 is: =RANK(C6,scores) Where scores is the named range C6:C13.
