---
title: "RANK function in Excel"  
description: "RANK function in Excel"  
author: "AVADHESH PATEL"  
published: 2013-03-30  
updated: 2019-09-07  
canonical: https://www.mindstick.com/articles/1177/rank-function-in-excel  
category: "excel"  
tags: ["excel"]  
reading_time: 1 minute  

---

# RANK function in Excel

In [Microsoft](https://yourviews.mindstick.com/view/81711/microsoft-disconnects-cortana-and-reinvents-it) Excel, the RANK [function](https://www.mindstick.com/articles/43970/purchase-suitable-wedding-dresses-for-your-wedding-function) returns the rank of a number within a set of numbers. The rank of a number is its size [relative](https://answers.mindstick.com/qa/105067/how-to-trade-with-the-relative-vigor-index) to other [values](https://www.mindstick.com/forum/159360/how-to-write-sql-query-to-join-comma-separated-values) in a list. (If you were to sort the list, the rank of the number would be its position.)\

##### Syntax

##### RANK(number,ref,[order])

The RANK function syntax has the following [arguments](https://answers.mindstick.com/qa/92535/what-are-the-different-types-of-arguments):

- Number Required. The number whose rank you want to find.
- Ref Required. An [array](https://www.mindstick.com/articles/14/array) of, or a [reference](https://www.mindstick.com/forum/34619/call-by-value-and-call-by-reference) to, a list of numbers. Nonnumeric values in ref are ignored.
- Order Optional. A number specifying how to rank number.

##### Note:

If order is 0 (zero) or omitted, Microsoft Excel ranks number as if ref were a list sorted in [descending order](https://www.mindstick.com/forum/160082/how-to-sort-the-results-of-an-sql-search-query-in-ascending-and-descending-order).

If order is any nonzero [value](https://www.mindstick.com/articles/23219/an-optimized-description-adds-value-to-experience-and-in-turn-effectively-guest-posting-packages), Microsoft Excel ranks number as if ref were a list sorted in [ascending order](https://www.mindstick.com/forum/157178/how-to-filter-1000-of-student-name-in-php-in-ascending-order).

![RANK function in Excel](https://www.mindstick.com/mindstickarticle/d14e319f-f4dd-4fc3-98b6-d28168df1456/images/8c8c25e2-187d-4248-bb15-c149ae95d55e.png)

---

Original Source: https://www.mindstick.com/articles/1177/rank-function-in-excel

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.