RANK
Syntax:
RANK ( number , number-list [ , order ] )
Description: Computes the rank of a number in a list of numbers. RANK
gives duplicate numbers the same rank. However, the presence of duplicate numbers affects the ranks of subsequent numbers.
Arguments:
Name |
Type |
Description |
---|---|---|
number |
number |
The number whose rank is to be found. |
number-list |
reference |
Designates the list of numbers. Non-numeric values in this list are ignored. |
order |
number |
Specifies how number is to be ranked. If zero or omitted, number is ranked as if the list were sorted in descending order. If order is any non-zero value, number is ranked as if the list were sorted in ascending order. |
Return Type and Value: number – The rank of a number in a list of numbers.
example: