RANK.AVG
Formulas / RANK.AVGRank a number against other numeric values.
=RANK.AVG(number, ref, [order])
- number - required, the number to rank
- ref - required, an array of other numbers to rank
- order - [OPTIONAL] an integer that determines if the rank is ascending or descending, defaults to zero
Examples
=RANK.AVG(94,B2:B8)This returns 4 because the value 94 is the fourth highest temperature out of the temperatures listed in cell range B2:B8. The temperature reached 94 on day 7/5/11.
=RANK.AVG(80,B2:B8)This returns 6 because the value 80 is the sixth highest temperature out of the temperatures listed in cell range B2:B8. The temperature reached 80 on day 7/10/11.
=RANK.AVG(87,B2:B8)This returns 5 because the value 87 is the fifth highest temperature out of the temperatures listed in cell range B2:B8. The temperature reached 87 on day 7/8/11.
=RANK.AVG(92,B2:B8)This returns 3 because the value 92 is the third highest temperature out of the temperatures listed in cell range B2:B8. The temperature reached 92 on day 7/4/11.
Summary
The RANK.AVG function is used to rank a number in a list of values, and returns the average rank if Order is 0 or omitted.
- The RANK.AVG function returns the rank of a number in a list of other numeric values, and is useful for comparing numeric values against a list of other numeric values.
Frequently Asked Questions
What is the RANK.AVG function?
What does the RANK.AVG function do?
Does the RANK.AVG function ignore non-numeric values?
What is the syntax for the RANK.AVG function?
What are the arguments for the RANK.AVG function?
- Number – The number to be ranked.
- Ref – The list of numbers to rank against.
- Order – (optional) The order to rank the numbers. 0 for descending, 1 for ascending.
