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

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

## Excel RANK.AVG Function:

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

In this post, we are going to explore how to use the **Excel RANK.AVG 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.AVG Function – Explanation:**

- This function **returns the rank of a number from a list of numerical values**.
- If more than one value has the same rank, then this function returns the average rank.

## Syntax:

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

### Arguments Explanation:

**Number –**  The number to rank.

**Ref –** It is the array that contains a set of numeric values.

**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 make it clear.

### Example 1:

- In the below screenshot, you can be able to see the input range in **Column C** and the rank of each student is listed in **Column E**.
- Here, the cells **E5** and **E8** contain the same rank that is **4.5** because the scores are the same. So, RANK.AVG function assigned the average rank to them.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-57.png)<figcaption id="caption-attachment-14044">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-53.png)<figcaption id="caption-attachment-14045">Example 2</figcaption>

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

## Verdict:

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

### See Also:

- [How to Use Excel FACTDOUBLE Function in Office 365?](https://geekexcel.com/how-to-use-excel-factdouble-function-in-office-365/)
- [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/)