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

How to use rank function to sort in excel

藏色散人
藏色散人Original
2020-02-11 10:37:2310245browse

How to use rank function to sort in excel

How to use rank function to sort in Excel?

After turning on the computer and entering the system, double-click the Excel document that needs to be edited to open it.

How to use rank function to sort in excel

After opening, you can see the values ​​that need to be sorted using the function. We double-click column C.

How to use rank function to sort in excel

Double-click and enter the RANK function. The second parameter is the area where the data series participating in the ranking is located.

How to use rank function to sort in excel

The third parameter can choose "ascending order" or "descending order". Here, select 1, which is "ascending order" for ranking.

How to use rank function to sort in excel

After selecting, press the Enter key and you can see that the ranking has been generated.

How to use rank function to sort in excel

Fill in the formulas downwards in order, that is, use the RANK function to sort.

How to use rank function to sort in excel

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of How to use rank function to sort 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