# How to Rank In Excel? [Step-by-Step] In this article, we’ll learn how to rank in Excel with the RANK() function. “Ranking” is used to determine the relative position of a number in a list of numbers relative to the others in the list.

There are three functions in Excel to rank data:

1. RANK
2. RANK.EQ
3. RANK.AVG.

In this article, we will learn how to use these three functions to rank our data.

Recommended read: How to merge cells in Excel?

## Setting up the dataset

Let us consider the marks of 10 students in a class to be used for ranking:

## 1. Using the RANK() function to Rank in Excel

The RANK function determines a number’s position in a list of numbers. A number’s rank is its size in comparison to other values in a list. Duplicate numbers are assigned the same rank.

Syntax: RANK(number,ref,[order])

• number: Required. The number whose rank you’re looking for.
• ref: Required. A list of numbers in an array or as a reference.
• order: Optional. A number that specifies how a number should be ranked. The list is sorted in descending order if the order is 0 (zero) or omitted. The list is sorted in ascending order if the order is any nonzero number.

Follow these steps to use the RANK function on our dataset:

• Go to cell C2, type `=RANK(B2,\$B\$2:\$B\$11)` and press Enter to generate the rank.
• Copy the formula for the entire list by dragging down the fill handle.

## 2. Using RANK.EQ function

The RANK.EQ function was introduced in Excel 2010 as an upgraded version of the RANK function. The rank of a number in a list of numbers is returned by this function. A number’s rank is its size in comparison to other values in a list. EQ stands for “equal,” as it gives duplicate numbers the same rank.

Syntax: RANK.EQ(number,ref,[order])

The RANK.EQ function has the following arguments:

• number: Required. The number whose rank you’re looking for.
• ref: Required. A list of numbers in an array or as a reference.
• order: Optional. A number that specifies how a number should be ranked. The list is sorted in descending order if the order is 0 (zero) or omitted. The list is sorted in ascending order if the order is any nonzero number.

Follow these steps to use the RANK.EQ function on the dataset:

• Go to cell C2, type =RANK.EQ(B2,\$B\$2:\$B\$11) and press Enter to generate the rank.
• Copy the formula for the entire list by dragging down the fill handle.

## 3. Using RANK.AVG function

The RANK.AVG returns a number’s rank in a list of numbers, or its size in comparison to other values in the list. It assigns the duplicate numbers an average rank. Syntax: RANK.AVG(number,ref,[order])

The RANK.AVG function has the following arguments:

• number: Required. The number whose rank you’re looking for.
• ref: Required. A list of numbers in an array or as a reference.
• order: Optional. A number that specifies how a number should be ranked. The list is sorted in descending order if the order is 0 (zero) or omitted. The list is sorted in ascending order if the order is any nonzero number.

Follow these steps to use the RANK.AVG function on the dataset:

• Go to cell C2, type =RANK.AVG(B2,\$B\$2:\$B\$11) and press Enter to generate the rank.
• Copy the formula for the entire list by dragging down the fill handle.

## Conclusion

In this article, we learned how to use RANK, RANK.EQ and RANK.AVG function to rank data in Excel.