How to do advanced filtering in Excel? What are the steps?

Before performing advanced filtering, you must first define your own condition area, and what is used to filter. First, copy and paste the column you want to filter and the column header names, and if there are multiple columns to filter, copy and paste them one by one into a blank area. Under the copied list header, write the content to be filtered, for example, the copied header is "gender", "age", and "age".

Education", write the conditions you want under the corresponding header, such as "male", "35", "undergraduate", when the conditions are written, click advanced filtering, circle the entire range of the data table to be filtered in the "list area", circle the header and the content under the header just copied and pasted in the "condition area", and then click OK to find the multi-column filter results.

However, there are three types of advanced filtering, the above is the most basic, without any "and", "or" relationship, the following are the other two cases:

When the filter appears in an AND relationship:

For example, if you want to filter the gender as male, between the ages of 25 and 35, and the person with a bachelor's degree, you should copy the three headers of gender, age and education when copying the header, but the conditions to be screened in the age column are between 25 and 35, and you can't write "25,<35" in a cell in excel, so you should copy it as "gender", "age", "age", "education" when copying the header, and write "male", "25", "35", "undergraduate" below the header, and then filter in the advanced level.

When an OR relationship appears in the filter:

For example, it is necessary to screen people who are not male, less than 35 years old, have a bachelor's degree or a female gender, are less than 20 years old, and have a technical secondary school education. At this time, the copied header is still "gender", "age", "education", write a or relationship condition in the first line under the header, it should be "male", "35", "undergraduate", after writing this condition, start another line, enter in the second line or get the second condition in the relationship, that is, "female", "20", "secondary school", and then advanced filtering.

To sum up, if it is an advanced filter related to relation, you need to write the filter conditions under the duplicate header in two cells respectively, and you also need to copy the two headers; If it is or relation, you need to write the conditions before and after or in two lines.

Advanced filtering for Excel.

Automatic filtering, which can only filter records that match a set of criteria from the worksheet at a time. And advanced screening, you can screen out multiple groups of stag muscles at the same time? Procedure for BR 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"·"Filtering"·"Advanced filtering"。

Step 3: Setup"Advanced filtering"Dialog box.

Data regions", the ** area in the original worksheet that needs to be filtered.

Condition area"to filter the criteria table area.

Method:"Options area, checked"The filter results are displayed in the original area"radio box, the filter result is displayed in situ (i.e., the records that do not meet the filter criteria are hidden);

Checked"Copy the filter results to other regions"radio box, the filter results will be copied to the specified area (a new ** will be generated).

Select Duplicate Records"checkbox.

If checked, the filter results do not contain duplicate records.

Step 4, Once the above settings are complete, click on it"Advanced filtering"dialog box"OK"button to filter the results to display.

The fifth step is to cancel the advanced filtering. Click"data" "Filtering"·"Advanced filtering"。

1. Open an excel trouser and piece:

2. Enter the students' grades, bury Chunkai here to simulate a set of data, a total of 11 people:

3. Input conditions, mathematics is greater than 90, English is greater than 90, note that the staggered column represents two different conditions, and the greater than the symbol uses the English input method:

4. Click on the data in the upper toolbar

5. Click to filter fat advanced:

6. Select the data you just entered in the list area

7. Select the bend calling area where the input is greater than 90 just now

8. As a result of the advanced screening, it can be seen that 8 people have a score greater than 90 in mathematics or English.

1. Open the Excel**2019 version on the computer, and then open the document you want to filter.

2. After opening the document, select a column and click Filter to filter the data.

3. Get the filtered data, then select all the data, and then press the del delete key to delete the data.

4. If the filtered data is deleted by del, the data will be deleted.

5. After deleting the data, cancel the filter, and the other data will come out, and the deleted data will be gone.

1. First of all, we open the excel software and prepare a data table, and then we want to filter out the ones with VN in the name.

2. Next, we click the arrow in the upper right corner of the name title cell, and select the equals option under the text filter in the pop-up interface.

3. Then in the pop-up custom filter interface, we enter the content of the loose manuscript to be filtered, <> 4, and finally return to the excel interface, you will see that the content that needs to be filtered has been selected by the screening base.

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.

Excel can use the advanced filter function by setting the condition area, positioning the "Advanced" in the "Data" menu toolbar, and performing advanced filtering on ** according to the given conditions. The details are as follows:

1. If you want to filter out the data with scores of more than 90 points in "Chinese", "Mathematics" and "English", you need to use the advanced filter function.

2. Set the condition area: There must be more than one blank line separating the condition area and the data area. Enter the criteria for advanced filtering on two blank lines from the data region.

3. Position the mouse in the data area to be filtered, and click the "Advanced" button in the "Data" menu toolbar. After such positioning, the program will automatically find the area to be filtered, otherwise you need to set the data filter area yourself.

4. The "Advanced Filtering" dialog box will pop up. The "List Area" in this dialog box automatically determines the area to be filtered for advanced purposes, and if there is an error, you can re-retrieve it.

5. Click the Zoom Dialog Window button on the right side of the Condition Area in the Advanced Filtering dialog box.

6. Drag the mouse to select the condition area in the advanced filter, and then press the "Window" button to return to the "Advanced Filter" dialog box.

7. Click the OK button, and the program will perform an advanced filter on ** according to the given conditions.

8. ** Screening out the data with scores of "Chinese", "Mathematics" and "English" all greater than 90 points.

Notes:

1. There must be more than one blank line between the condition area and the data area.

2. When [Show filter results in original area], you need to view other data, which can be achieved through the [Clear] command.