Home  >  Article  >  Topics  >  How to use rank function in excel

How to use rank function in excel

青灯夜游
青灯夜游Original
2021-02-18 11:33:21128578browse

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])”.

How to use rank function in excel

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.

How to use rank function in excel

Usage example:

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

How to use rank function in excel

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.

How to use rank function in excel

How to use rank function in excel

Upgrade usage

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

How to use rank function in excel

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

How to use rank function in excel

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)).

How to use rank function in excel

How to use rank function in excel

##The fourth one, finally, you need to add parentheses. Finally, there is this, =RANK(E28,($E $28:$E$31,$H$28:$H$31)). Finish.

How to use rank function in excel

Related learning recommendations:

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn