# RANK.AVG

Formulas / RANK.AVG
Rank 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.

What is the RANK.AVG function?
The RANK.AVG function is a Sourcetable formula that returns the rank of a number in a list of values. The rank is the position of the number in the list.
What does the RANK.AVG function do?
The RANK.AVG function returns the average rank of a list of values. The order argument determines how to rank the numbers.
Does the RANK.AVG function ignore non-numeric values?
Yes, the RANK.AVG function ignores non-numeric values in the ref argument.
What is the syntax for the RANK.AVG function?
The syntax for the RANK.AVG function is: RANK.AVG(number, ref, [order]).
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. 