What is the difference between Excel automatic filtering and advanced filtering?

#What is the difference between Excel automatic filtering and advanced filtering?

1. Different usage methods:

Auto filter, click on the title row, then click on data-automatic filter, and then click on the arrow that pops up in each cell to filter it. Content.

For advanced filtering, you must first remove automatic filtering, click on the title row, then click on data - automatic filtering (with a check mark in front), and then remove automatic filtering. Then select a column, then click Data-Advanced Filtering, and then click Unduplicated Items. At this time, the list becomes information with unique contents in this column.

2. Different ways of processing filtered data:

After automatic filtering filters out the data in the table, the data is still in the original table.

Advanced filtering is to filter out the data in the table and copy the data to blank cells.

3. Different filter areas:

Auto filter can only filter in fixed columns, while advanced filter can freely select the filter area.

Detailed analysis of the difference

1. Automatic filtering

• If you want to perform automatic filtering operation, you need to add it to our data list There must be column numbers, and the steps are as follows:

• Select cells in the list of data to be filtered.

• Select the "Filter" command in the "Data" menu, and then select the "AutoFilter" command from the submenu. After that, we can insert down arrows next to each column mark in the data list.

• Click the arrow in the column containing the data we want to display, and you will see a drop-down list.

• Select the items to be displayed, and we can see the filtered results in the worksheet.

2. Advanced filtering

It is convenient and fast to use "automatic filtering" to find records that meet the criteria, but the search conditions of this command cannot be too complex. If you want to execute For more complex searches, you must use advanced filtering commands.

To execute the advanced filtering command, the data list must have column tags. The steps to perform advanced filtering are as follows:

• Establish conditions on the worksheet away from the filtered data list area. As shown in the figure below, in this example, the set condition is customers with salary ">=1600". If the condition is an expression of "equal to (=)", when entering the condition in the condition area, a single quotation mark (') should be added before the equal sign.

• Select cells in the data list.

• Select the "High Filter" command in the "Filter" submenu of the "Data" menu.

• Select the "Show filter results in the original area" radio button in the "Method" area.

• In the "Data Area" box, specify the data area;

• In the "Conditional Area" box, specify the conditional area;

• To exclude identical rows from the results, you can check "Select unique records".

• Click the "OK" button and you will see the results that meet the conditions.

Before using the "Advanced Filter" command, we must specify a condition area in order to display rows that meet the conditions. We can define several conditions (called multiple conditions) to select Rows that match all criteria.

For setting a conditional area, it is the same whether you enter a comparison condition or use a calculation condition. We can use the following steps to establish a conditional area:

• In a blank , type the column tag (field name) you want to use to filter the data list.

• Type the required criteria in the rows below the column labels.

Set the conditions that satisfy the logical "AND" relationship

Recommended tutorial: "Excel"

The above is the detailed content of What is the difference between Excel automatic filtering and advanced filtering?. For more information, please follow other related articles on the PHP Chinese website!