RANK function
Summary
Returns the rank of a number in a list of numbers
Syntax
RANK(number,ref,[order])
The RANK function syntax has the following arguments:
• Number: Required. The number whose rank you want to find.
• Ref: Required. A reference to a list of numbers. Nonnumeric values in ref are ignored.
• Order: Optional. A number specifying how to rank number. If order is 0 (zero) or omitted, Microsoft Excel ranks number as if ref were a list sorted in descending order. If order is any nonzero value, Microsoft Excel ranks number as if ref were a list sorted in ascending order.
• Number: Required. The number whose rank you want to find.
• Ref: Required. A reference to a list of numbers. Nonnumeric values in ref are ignored.
• Order: Optional. A number specifying how to rank number. If order is 0 (zero) or omitted, Microsoft Excel ranks number as if ref were a list sorted in descending order. If order is any nonzero value, Microsoft Excel ranks number as if ref were a list sorted in ascending order.
Example
=RANK(A3,A2:A6,1)
=RANK(A2,A2:A6,1)
=RANK(A2,A2:A6,1)