Home  >  Article  >  Topics  >  How to implement two-column bundle sorting in Excel

How to implement two-column bundle sorting in Excel

醉折花枝作酒筹
醉折花枝作酒筹Original
2021-04-29 11:44:2922456browse

Method: 1. Select the cells that need to be sorted; 2. Click "Start" - "Sort" - "Custom Sort" at the top of the page; 3. Select "Add Condition" and click on "Main Keywords" " column select the column that needs to be sorted, and select the required "order"; 4. Select another column in the "Secondary Keywords" column, and select the required "order"; 5. Click the "OK" button.

How to implement two-column bundle sorting in Excel

The operating environment of this tutorial: windows7 system, WPS Office 2019 version, Dell G3 computer.

We open Excel and enter test data, at least two columns.

How to implement two-column bundle sorting in Excel

Select all data, click [Start]-[Sort] on the menu bar, and select custom sorting in the drop-down list

How to implement two-column bundle sorting in Excel

In the pop-up "Sort" dialog box, select "Add Condition", in the "Primary Keyword" column, select "Column A", select "Descending Order", in the "Secondary Keyword" column, Select "column b" and select "descending order".

How to implement two-column bundle sorting in Excel

Click the "OK" button.

How to implement two-column bundle sorting in Excel

Related learning recommendations: excel tutorial

The above is the detailed content of How to implement two-column bundle 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