Google Sheets Rank Function

This article will introduce you how to use the RANK function in google sheets, and will show you a good example to better understand the usage of the RANK function.

Google Sheets Rank Function Description

The Google Sheets Rank function is used to return the ranking of a given number from a list. If there are duplicate numbers in the list, then the numbers will be in the same rank.

The RANK function is a build-in function in Google Sheets and it is categorized as a Statistical Function.

Google Sheets Rank Function Syntax

The syntax of the Google Sheets Rank function is explained as follows:

= RANK (number,reference ,[order])

Where the arguments of the RANK function are as follows:

  • Number – This is a required option, the number that you would like to get ranked
  • reference – This is a mandatory option, it may be an array or cell region, or a cell reference contains the specified number
  • Order – This is an optional, you can specify the number of 0 or 1 to determine the type of sorting; if the value of order is 1, it means that the RANK function will be sorted in ascending order, otherwise it will be ranked in descending order.

Google Sheets RANK Function Examples

The below examples will show you how to use Google Sheets RANK Function to get the rank of a given value within a supplied range of cells.

Example 1: If you want to get the sorting of number 2 in a given list B1:B4 in google sheets, then you can use the RANK function to do so with the following formula:


google sheets rank function1

Note: The number 2 must be a value that exists in B1:B4, otherwise google sheets will report the error “Rank has no valid input data“.

google sheets rank function1

See Also:

Related Posts

Rank Data with Multiple Criteria in google sheets

If you are an enthusiastic Google Sheets user, then you may have an urgent task to rank a specified datelist based on given multiple criteria; you can easily perform this task manually, which is also feasible, but it only works ...

Sort Dynamic Data in google sheets

 This article will talk about how to sort the dynamic data in google sheets automatically. How to use RANK formula to sort the data of a given dynamic range in google sheets. Sort Dynamic Data suppose you have a list ...

Reverse Rank Order in google sheets

This article will talk about how to rank the given data in reverse order in google sheets. You can use Google sheets RANK function to rank the data. By default, the largest value in the data table will be ranked ...

Rank Numbers without Repetitive Ranks in google sheets

This article will guide you how to rank numbers in a range with unique ranking in google sheets. How to use the Rank function in google sheets to get a unique ranking for ranges with duplicate values. Ranking without Repetitive ...

Rank Numeric Values with Duplicate in Google Sheets

Suppose you have an urgent task of ranking a list with duplicate values, what would be the first approach you would think of? Is there a quick and easy way to do this task in Google Sheets? This article will ...