Formulas > =RANK.AVG()

How To Use RANK.AVG() Function in Google Sheets


Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the average rank of the entries will be returned.

Common Questions about the RANK.AVG Formula:
-What is the syntax of the RANK.AVG formula?
-How does the RANK.AVG formula work?
-What values can the RANK.AVG formula take?

How can the RANK.AVG formula be used appropriately?
-The RANK.AVG formula can be used to assign a numerical rank to a list of values. It provides the percentile rank of a data value based on a list of values. This formula requires two numbers to be specified; the value to rank, and the list of values to be ranked.

How can the RANK.AVG formula be commonly mistyped?
-The formula may be mistakenly typed as RANK.AVR or RANK.AVERAGE.

What are some common ways the RANK.AVG formula is used inappropriately?
-The RANK.AVG formula can be used incorrectly if incorrect values are specified, or if it is used to rank non-numerical data.

What are some common pitfalls when using the RANK.AVG formula?
-RANK.AVG is based on the average of the group of numbers, so ties will result in the same rank being given.
-It is important to remember that ranking is 1-based, so the lowest value will always be assigned a rank of 1, and the highest rank will be the total number of values in the list.

What are common mistakes when using the RANK.AVG Formula?
-The most common mistake when using the RANK.AVG Formula is to forget to include the list of values to be ranked, but instead only specifying the value.
-Another common mistake is to forget to specify the 0th argument as FALSE, which is necessary to receive the 1-based, relative rank of a value.

What are common misconceptions people might have with the RANK.AVG Formula?
-Some believe that the RANK.AVG formula will assign numerical rankings to non-numerical data. This is incorrect, as the formula only works to assign numerical rankings to numerical data. 
-Another misconception is that the formula will work on values which are repeated more than once in the list. This is also incorrect, as the RANK.AVG formula will assign the same rank to multiple values which are the same.

How To Actually Use RANK.AVG() in Sheets

RANK.AVG(value, data, [is_ascending])

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the RANK.AVG() formula:

Rank.avg function example in excel

This video shows you how to get average rank in a list of same values using rank.avg formula in MS Excel 2019 Office 365.

Generate a RANK.AVG() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.