Click Sort and Filter on the toolbar above the excel file and select Custom Sort. You can sort by grade in descending order, that is, in descending order. When the total scores are equal, they will be sorted by student number. Increasing sort, that is, ascending order.
The specific method is as follows:
1. Enter the grades that need to be sorted. Here are some simulated grades:
2. Click Sort and Filter on the toolbar above the excel file and select Custom Sort:
3. Sort by grades in descending order, that is, in descending order. When the total scores are equal, sort by study. Sort by increasing number, that is, in ascending order.
#4. After the setting is completed, you can see that the total scores are sorted in descending order, that is, from large to small. When the scores are the same, they are sorted in ascending order, that is, from small to large.
For more Excel-related technical articles, please visit the Excel Basic Tutorial column!
The above is the detailed content of How to sort by total score in excel. For more information, please follow other related articles on the PHP Chinese website!