RANK Function Explained
The RANK function in Microsoft Excel returns the rank of a number within a set of numbers. It takes two arguments: the number to be ranked and an optional order argument that specifies whether the rank should be in descending or ascending order. The rank is returned as a number, with 1 being the highest rank.
RANK Function Syntax
RANK(number,ref,order)
- number: The number whose rank you want to find.
- ref: An array of, or a reference to, a list of numbers. The numbers in ref are ranked in order.
- order: A number: 1 (smallest to largest) or 0 (largest to smallest).