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.

Frequently Asked Questions

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.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV