Home  >  Article  >  Topics  >  How to sort by total score in excel

How to sort by total score in excel

尚
Original
2019-06-12 16:56:0137154browse

How to sort by total score in excel

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:

How to sort by total score in excel

2. Click Sort and Filter on the toolbar above the excel file and select Custom Sort:

How to sort by total score in excel

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.

How to sort by total score in excel

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

How to sort by total score in excel

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!

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
Previous article:How to enlarge wps tableNext article:How to enlarge wps table