RANK.AVG

The RANK.AVG function in Google Sheets returns the rank of a value within a dataset. When multiple entries share the same value, RANK.AVG returns the average of the ranks those tied entries would otherwise occupy, unlike RANK or RANK.EQ which return the top rank for ties. Dive into our comprehensive guide to master its application.

Parameters

• value: The value whose rank you want to determine.
• data: The range of data containing the value.
• [is_ascending]: [Optional] Whether to rank in ascending order. 0 or omitted ranks in descending order; any nonzero value ranks in ascending order.

Step-by-Step Tutorial

1. Ranking a value in descending order:

   • Example: If A1:A5 contains 10, 20, 20, 30, 40, then =RANK.AVG(20, A1:A5) returns 3.5 (the average of ranks 3 and 4, since both 20s tie).

2. Ranking a value in ascending order:

   • Example: =RANK.AVG(20, A1:A5, TRUE)
   • Result: 2.5

Use Cases and Scenarios

1. Leaderboard Scoring: Rank competitors fairly when scores are tied, avoiding gaps in the ranking.
2. Academic Grading: Assign averaged class ranks to students with identical test scores.
3. Sports Statistics: Rank teams or players where tied performance metrics need a balanced rank.

Related Functions

• RANK: Returns the rank of a value in a dataset.
• RANK.EQ: Returns the rank of a value, giving tied values the same top rank.
• LARGE: Returns the nth largest value in a dataset.

Related Articles

• Understanding Statistical Functions in Google Sheets