Function finds rank for a specific number within given range. Rank Function is very useful to calculate various positions within a range. Other words Rank Function returns the rank of a number in a list of numbers.
=RANK(number, ref, [order])
- number: a mandatory parameter, refers to the number which needs to be ranked within ref.
- ref: a mandatory parameter, refers to a range within rank needs to be found
- order: an optional parameter, excel by default takes descending order rank. But user can change the order