This function returns the rank of a number within a list of numbers. The rank indicates the number’s relative size compared to other values in the list. If the list were sorted, the rank would correspond to the number’s position.
Syntax:
RANK.EQ(number; ref; [order])
Arguments:
- number(required): The value for which you want to determine the rank.
- ref(required): An array or reference to a list of numeric values. Non-numeric values in the reference are ignored.
- order(required): Specifies the ranking order:
- If 0or omitted: Ranks numbers as if the reference were sorted in descending order (highest value = rank 1).
- If non-zero: Ranks numbers as if the reference were sorted in ascending order (lowest value = rank 1).
Background:
For additional details about ranking functionality, refer to the documentation for the RANK() function.
Example:
Usage examples for the RANK.EQ() function can be found in the figure below.
