How to use rank function in excel

In excel, the rank function is mainly used for sorting. It can return the numerical ranking of a column of numbers. The ranking of the numbers is relative to the size of other values ​​​​in the list; the syntax format is "RANK(number,ref ,[order])”.

The operating environment of this tutorial: Windows 10 system, Microsoft Office Excel 2016 version, Dell G3 computer.

Rank function in excel

The rank function represents sorting. There are three main parameters, the target area and ascending or descending order

Syntax:

RANK(number,ref,[order])

RANK Function syntax has the following parameters:

Number: Required. The number whose ranking is to be found.

Ref: required. Array of lists of numbers, a reference to a list of numbers. Non-numeric values ​​in Ref are ignored.

Order: Optional. A number that specifies how the numbers are ranked.

• If order is 0 (zero) or omitted, Microsoft Excel ranks numbers based on ref being a list in descending order.

• If order is non-zero, Microsoft Excel ranks numbers based on ref being a list in ascending order.

Usage example:

Just make a demonstration, then here it is, =RANK(E15, E15:E22).

Finally, because batch processing operations are required, you can use regional references or add absolute references, then there is =RANK(E15,$E$15:$E$22), and finally The pull-down is complete.

Upgrade usage

The first one, sort by multiple columns, then it’s still the same , using the rank function.

The second one, then here it is, =RANK(E28,E28:E31,H28:H31). (Others remain unchanged, separate multiple areas with commas)

The third one, then, is not enough, you have to add the absolute value, and there you have it, =RANK( E28,$E$28:$E$31,$H$28:$H$31)).

excel tutorial

The above is the detailed content of How to use rank function in excel. For more information, please follow other related articles on the PHP Chinese website!