How to sort results in excel

How to sort results in excel?

How to sort results in excel:

Rank all students in the table according to their total score

1. First select all the data

2. Click [Start] and click the drop-down arrow on the right side of [Sort and Filter]

3. Select [Custom Sort] in the drop-down list, and the [Sort] dialog box will appear.

4. Select [Total Score] for [Main Keyword], select [Value] for [Sort By], select [Descending Order] for [Order], and click [OK]

5. All data are arranged from high to low according to the total score

6. Add on the right A column of rankings, enter the ranking number

This article comes from the Excel basic tutorial column: http://www.php.cn/topic/excel/

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