How to Use Excel RANK.EQ Function in Office 365? – [with Examples]
Tags: excelfunctions, excelrankeqfunctioni
Published: 2020-09-17 07:30:26

---
title: How to Use Excel RANK.EQ Function in Office 365? – [with Examples]
published: true
date: 2020-09-17 05:06:05 UTC
tags: ExcelFunctions,ExcelRANKEQFunctioni
canonical_url: https://geekexcel.com/how-to-use-excel-rank-eq-function-in-office-365-with-examples/
---

## RANK.EQ Function:

![RANK.EQ Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/RANK.EQ-Function.png)<figcaption id="caption-attachment-14054">RANK.EQ Function</figcaption>

In this guide, you will learn the usage of **Excel RANK.EQ**  **Function in Office 365** with its syntax, explanation, and examples. Let’s step into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## **RANK.EQ**  **Function – Description:**

- This function **returns the rank of a number from a list of numerical values**.
- If more than one value has the same rank, this function will assign a higher rank to them.

## Syntax:

**=RANK.EQ(number, ref, [order])**

### Arguments Explanation:

**Number –**  The number to rank.

**Ref –** It is the array that contains a set of numeric values. If any non-numeric value given as a ref argument, this function will ignore it.

**Order – ** It is an optional one. If the order is 0 or omitted, it will sort the array in descending order. If the order is a non-zero value and then it will sort the array in ascending order.

### Note:

- If either of the argument is non-numeric and then this function returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).
- If there are no arguments in the array, it will return [**#N/A! Error**](https://geekexcel.com/how-to-replace-n-a-or-zero-in-vlookup-with-blank-or-specified-text-in-excel/).

## Examples:

Let’s see some examples to understand how RANK.EQ Function will work.

### Example 1:

- In the following image, you can be able to see the input range in **Column C** , and its corresponding rank values are listed in **Column E**.
- Here Lisaa, Tony, and Lilly have the same score 82, so this function assigns the higher rank ( **4** ) to them and skips the next two ranks **5** & **6**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/chrome_cTDAQF5GpW.png)<figcaption id="caption-attachment-14080">Example 1</figcaption>

### Example 2:

- If either of the argument is non-numeric and then this function returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-54.png)<figcaption id="caption-attachment-14052">Example 2</figcaption>

From the above example, you can see that the RANK.EQ function does not accept any non-numerical values as input. If you use any non-numerical value, then it returns the #VALUE! Error.

## Summary:

In this guide, you can clearly learn the usage of **Excel RANK.EQ**  **Function in Office 365** with its syntax, explanation, and examples. Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [How to Use Excel FREQUENCY Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-frequency-function-in-office-365-with-examples/)
- [How to Use Excel STDEV.S Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-stdev-s-function-in-office-365-with-examples/)