How to Use Excel RANK Function (Examples + Video)

Excel RANK Function (Example + Video)

Excel RANK Function

When to use Excel RANK Function

RANK function can be used when you want to rank a number against a list of numbers.

What it Returns

It returns a number that represents the relative rank of the number against the list of numbers.

Syntax

=RANK(number, ref, [order])

Input Arguments

  • number – the number that you want to rank.
  • ref – the list of numbers against which you want to rank the number argument. It could be a range of cells or an array.
  • [order] – (optional) a number that specifies how to rank (ascending or descending order)

Additional Notes

  • If Order is:
    • 0 or omitted – Highest number gets 1st rank.
    • 1 – Lowest numbers gets 1st rank.
  • Duplicate values get the same rank.
    • If there are 2 numbers with the 2nd rank, the next number gets a rank of 4. Similarly if 2 numbers have the 2nd rank, the next number gets a rank of 4.
  • Microsoft team has introduced a new function RANK.EQ. It works exactly the same way as RANK function. MS team encourages to use this new function for improved accuracy. RANK function has been retained for backward compatibility.

Excel RANK Function – Live Example

Excel RANK Function – Video Tutorial

Related Excel Functions:

You May Also Like the Following Excel Tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Picture of Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

Leave a Comment

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster