How To Use: RANK Function

The RANK function returns the rank of a number within an array or set numbers without sorting the numbers.

RANK is an inbuilt function in Excel. It is under the category of Statistical Functions. As a worksheet function, you can enter the RANK function as part of a formula in a cell of a worksheet.

This function determines the relative position or order of one value in a given range of data.

Thus, it is not necessary to sort data in either ascending or descending order to see the rankings of values in a given range of data.

Syntax for RANK Function

=RANK(number,ref,[order])

Arguments

Number: The number whose rank you want to find.

Ref: An array of, or a reference to, a list of numbers. Non-numeric values in ref are ignored.

Order: A number specifying how to rank number.

If the order argument is O, then Rank are given in descending order.

But if order argument is 1, it ranks in ascending order.

In any case the argument is omitted, then RANK function assumes it as 0.

We have created the infographics for the RANK Function. With the help of these infographics, you can easily learn step by step process for using this excel functions.

Furthermore, Excel consists of many inbuilt functions which are helpful in the analytical and statistical study of number.

Simply follow the instructions in the infographics below:

RANK gives duplicate numbers the same rank. However, this will affect the ranks of subsequent numbers.

For example, if there are two numbers both have the rank of 2, then no number will have a rank of 3. The following next number in the range or list will have a rank of 4.

To learn other function like CUMPRINC, ACCRINTM and PRODUCT Functions, please click on the name of the function.

Additionally, you can download other accounting templates like Weekly Timesheet, Salary Sheet and Checkbook Register from here.

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries please share in the comment section below. I will be more than happy to assist you.