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.

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

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

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

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

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

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!