# 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 Ranks

Suppose you try to use the RANK function to rank values in a range of cells that have two or more duplicate values. And the RANK function will return the same ranking for duplicate values in the cell range.

For example, if you have a list of data containing values in column A (10, 12, 12, 14, 16), the RANK function will return a list of ranked values in another column as `5, 4, 4, 2, 1`. The returned result may not be the one that you expect. Because you maybe expect the result as` 5, 4, 3, 2, 1`. At this time you can use the RANK function and in combination with COUNTIF function to build a new complex google sheet formula to return a unique ranking value.

The formula is as follows：

`=RANK(A2,\$A\$2:\$A\$6,0)+COUNTIF(\$A\$2:A2,A2)-1`

You can enter the above google sheets formula in cell B2, and then press the Enter key to make the formula take effect;

Fill Handle can be dragged down until the cell B6, so that other cells can also apply the formula.

From the above screenshot you can see that the unique ranking results are sorted in descending order.

If you wish the unique ranking results for the given cell range is sorted in ascending order, you can change the order type of the RANK function to `1`, the formula is changed as follows:

`=RANK(A2,\$A\$2:\$A\$6,1)+COUNTIF(\$A\$2:A2,A2)-1`

You can enter the above google sheets formula in cell C2, and then press the Enter key to make the formula take effect;

Then you can be dragged Fill Handle can be dragged down until the cell C6, so that other cells can also apply the formula.

### Related Functions

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 syntax of the Google Sheets Rank function is explained as follows:The syntax of the Google Sheets Rank function is explained as follows:= RANK (number,reference ,[order])…
The google sheets COUNTIF function is used to count the number of cells in a cell range that meet a given condition.The syntax of the Google Sheets COUNTIF function is explained as follows: = COUNTIF (range, criteria)…
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 ...

Rank Based on Specific Value in google sheets

This article will guide you how to sort the values in a given column based on a specific value in another column in google sheets. How to sort a range of values in google sheets by using IF function and ...

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

Sidebar