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

`=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.

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.

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.

The RANK.AVG function returns the average rank of a list of values. The order argument determines how to rank the numbers.

Yes, the RANK.AVG function ignores non-numeric values in the ref argument.

The syntax for the RANK.AVG function is: RANK.AVG(number, ref, [order]).

- 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.

Drop CSV