Automatic filtering, only records that meet a set of conditions can be filtered from the worksheet at a time. There is also advanced filtering, which can filter out multiple groups of bars at the same time? Shovel muscle? Br> Operating Steps of Advanced Filtering:

The first step is to list the filter conditions.

In the filter criteria table, the first row is the header row, and the contents of the cells are the filter criteria (fields).

In the filter condition table, one or more sets of filter conditions are specified. Each line (except the header line) corresponds to a filter condition. Each row condition is independent. In other words, if there are two rows of filter criteria, the final filter result includes both records that meet the first row of filter criteria and records that meet the second row of filter criteria. Allow blank cells except the header row.

Tip: In order to prevent hidden columns in the original worksheet, the filter condition table is usually made below or to the right of the original table.

Step 2: Select all or part of the original worksheet, but it must contain the header row. Then click Data, Filters and Advanced Filters.

Step 3: Set the Advanced Filter dialog box.

"Data area" refers to the table area in the original worksheet that needs to be filtered.

"Condition area", filter the condition table area.

"Method" option area,

Select the "Show filtering results in original area" radio box, and the filtering results will be displayed in the original location (that is, records that do not meet the filtering conditions will be hidden);

Select the "Copy filter results to other areas" radio box, and the filter results will be copied to the designated area (generate a new table).

Select non-duplicate records check box. If selected, duplicate records will not be included in the filtering results.

Step 4: After completing the above settings, click OK in the Advanced Filtering dialog box to display the filtering results.

Step five, cancel the advanced screening. Click Data, Filters and Advanced Filters.