Home  >  Article  >  Topics  >  How to perform complex sorting in excel

How to perform complex sorting in excel

藏色散人
藏色散人Original
2020-03-16 09:36:487554browse

How to perform complex sorting in excel

How to perform complex sorting in excel

In the following score table, it is now necessary to sort in descending order by English score. If the English scores are the same, they are sorted in descending order by math scores.

Recommended: "excel tutorial"

How to perform complex sorting in excel

Position the mouse on any cell in the table data area. This step is very important.

How to perform complex sorting in excel

Click the "Data" menu label and click the "Sort" button in the toolbar.

How to perform complex sorting in excel

The "Sort" dialog box will pop up. Click the arrow below to the right of Primary Keywords and select the English field you want to sort by. The sorting basis is "numeric value" and the order is "descending order".

How to perform complex sorting in excel

#Click the "Add Condition" button to add a "Secondary Keyword" condition.

How to perform complex sorting in excel

Click the following arrow to the right of Secondary Keywords and select the Math field you want to sort by. The sorting basis is "numeric value" and the order is "descending order".

How to perform complex sorting in excel

Click the "OK" button and the table will be sorted according to the set conditions. From the table we can see that when the English scores are the same, the math scores are sorted in descending order. This is the complex sorting method in Excel, also called multi-keyword sorting.

How to perform complex sorting in excel

The above is the detailed content of How to perform complex sorting 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