Formulas > =RANK()

How To Use RANK() Function in Google Sheets


Returns the rank of a specified value in a dataset.

Common questions about the RANK formula:
What parameters does the RANK formula require? What data types can be used with the RANK formula? What are the limitations of the RANK formula?

How can the RANK formula be used appropriately?
The RANK formula can be used to sort values in ascending or descending order depending on the arguments supplied. To use the formula properly, you will need to provide the Range, the Number of values you want to rank, and the Order of the rank (Ascending or Descending).

How can the RANK formula be commonly mistyped?
The RANK formula is generally entered as “=RANK” followed by Range, Number and Order parameters. Sometimes users may mistype this formula and enter “=RANK” with no further arguments.

What are some common ways the RANK formula is used inappropriately?
The RANK formula is typically used to compare a set of values. If it is used in a situation that is not comparing values, it may not give the expected results. Additionally, if the parameters entered are of the wrong data type, the formula may return an incorrect result.

What are some common pitfalls when using the RANK formula?
One common pitfall when using the RANK formula is to misunderstand how it orders the range. It is important to remember that the RANK formula only orders the specified range; it does not display in order beyond that. Additionally, if two of the values in the range you are ranking are equal, the RANK formula will assign the same rank to both values, which can have unexpected results.

What are common mistakes when using the RANK Formula?
Common mistakes when using the RANK formula include omitting parameters, entering the wrong data type as a parameter, or incorrectly entering the order of the rank.

What are common misconceptions people might have with the RANK Formula?
Some people may mistakenly believe that the RANK formula orders all values in their worksheet, when in fact it only orders the specific range of values specified as a parameter. Additionally, some may believe that it is necessary to input all values when using the formula, when in fact it is only necessary to input the range.

How To Actually Use RANK() in Sheets

RANK(value, data, [is_ascending])

1Better Sheets Tutorial

How to use alternating colors in your spreadsheets.

Learn more about the RANK() formula:

Generate a RANK() 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.