How to use Excel Advanced Filtering?

Advanced filtering for Excel.

Automatic filtering, which can only filter records that match a set of criteria from the worksheet at a time. Advanced filtering, on the other hand, allows you to filter out records that match multiple groups of conditions at the same time.

Procedure for Advanced Filtering:

The first step is to create a filter table.

In the filter condition table, the first row is the header row, where the contents of the cell are the filter criteria (fields).

In the filter table, one or more sets of filter conditions are specified. Each row (except the header row) corresponds to a filter. Each line condition is independent.

In other words, if there are two rows of filters, the final filter result contains both records that match the first row and the second row. Blank cells are allowed except for the header row.

In the second step, select all or part of the original worksheet, but it must contain the header row. Then click Data, Filter, and Advanced Filter.

The third step is to set up the Advanced Filtering dialog box.

Data region: the ** region in the original worksheet that needs to be filtered.

Condition area: The filter condition table area.

In the method option area, select the radio box to display the filter results in the original area, and the filter results are displayed in situ (that is, the records that do not meet the filter conditions are hidden);

Select the Copy filter results to other regions check box, and the filter results will be copied to the specified region (a new ** will be generated).

Select the Duplicate Records check box, and if it is selected, the filter results do not contain duplicate records.

Fourth, after the above settings are completed, click the OK button in the Advanced Filtering dialog box, and the filtering results can be displayed.

The fifth step is to cancel the advanced filtering. Click Data Filtering & Advanced Filtering.

The purpose of data screening is to improve the availability of relevant data collected and stored before, which is more conducive to later data analysis. Data filtering consists of three parts: data extraction, data cleaning, and data loading.

1. The usage of excel advanced screening is very simple, first of all, we open a payroll for demonstration.

<>3. Click Advanced Filter in Excel data.

4. After selecting the excel advanced filter, the list area will be automatically recognized, and it will be displayed as a dotted line, and we click the button on the right side of the condition area.

5. Drag the selection excel condition area, and then click the button on the right.

6. At this time, it will return to the Excel advanced filter window, and we click OK.

<>7. At this time, we can see that the excel advanced screening has been completed, and the personnel with a basic salary greater than 3100 and a bonus greater than 2200 have been displayed.

Preparation Tools Materials: A computer with Windows 10, Microsoft Office Home and Student Edition 2016 Excel software.

Excel with"Advanced filtering"The function filters out the records with scores greater than 80 in all three subjects as follows:

2. Then select the condition area A1: E2 in the condition area and click OK.

3. After confirmation, you can get a list of statistics, mathematics, English and economics with a score of 80 points or more. Pay attention to the serial number.

4. You can also use the sorting method to directly release the ascending or descending order of a single topic.

5. Select the sorting area A4: E12, click on the data, and a drop-down triangle will appear in the title bar after filtering. Open any triangle, select ascending or descending, and then click OK.

The steps to use Excel Advanced Filtering are as follows:

1. Open the excel workbook Kaichang on the computer desktop.

2. After the system enters Start by default, click Data on the right side of Start.

3. Click Filter in the Sort and Filter groups.

4. Enter a filter condition in the area that does not contain data, for example, enter the total sales in cell i19 and enter "500000" in cell i20.

5. Position the cursor in any cell in the data region, and click Advanced in the Sort and Filter group.

6. The advanced filter dialog box will pop up, and the selection method is to display the filter result in the original area, and then click the collapse button on the right side of the text box in the condition area.

7. Pop up the Advanced Filtering - Condition area, and then select the condition area i19:i20 in the worksheet.

8. Click OK to return to the worksheet, and the effect of sieving dry Sun Hu will come out.

When using excel to create**, if you want to filter out what you want, how to do it, here's how to do it.

1. First open the excel sheet, select the cell to start filtering, and [Start] page.

2. Then in the options that open, click [Filter].

3. Then click [Filter] in the drop-down box.

4. At this time, in **, there is a screening mode.

5. Click on the triangle symbol. Under Content Filtering, select the content you want to filter.

6. In this way, you can filter out the content you want.

Open the Tsai Xiang excel file.

Open the excel file, enter the Nian Lingbo filter conditions in the empty space next to **, select the **data area and the first row label, and click [Data].

Go to Advanced Filtering.

Click [Advanced] in the [Sort and Filter] tab, and click [OK] in the pop-up prompt dialog box to enter [Advanced Filtering].

Select the filter field you entered.

Click the arrow icon on the right side of the Condition Area, select the input filter area, and click OK.

How to use advanced filtering in Excel:

Tool: Excel in Office

Select the data region.

Select Advanced filtering.

Select the second way, then select the entire data table in the list area, select the condition in the condition area, copy it to any blank cell, and click OK.