RANK.EQ function
Summary
Returns the rank of a number in a list of numbers
Syntax
RANK.EQ(number,ref,[order])
The RANK.EQ function syntax has the following arguments:
• Number Required. The number whose rank you want to find.
• Ref Required. An array of, or a reference to, a list of numbers. Non-numeric values in Ref are ignored.
• Order Optional. A number specifying how to rank number.
• Number Required. The number whose rank you want to find.
• Ref Required. An array of, or a reference to, a list of numbers. Non-numeric values in Ref are ignored.
• Order Optional. A number specifying how to rank number.
Example
=RANK.EQ(A2,A2:A6,1)
=RANK.EQ(A6,A2:A6)
=RANK.EQ(A3,A2:A6,1)
=RANK.EQ(A6,A2:A6)
=RANK.EQ(A3,A2:A6,1)