RANK.AVG function
Summary
Returns the rank of a number in a list of numbers
Syntax
RANK.AVG(number,ref,[order])
The RANK.AVG 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. Nonnumeric 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. Nonnumeric values in Ref are ignored.
• Order Optional. A number specifying how to rank number.
Example
=RANK.AVG(94,B2:B8)