How to operate advanced filtering in data filtering in Excel?

The focus is on the conditional area here and it is not easy for everyone to understand ......

Data that can be filtered using advanced filtering has a requirement, that is, there must be a "Column" ......The data name at the top of each column.

A conditional area is also a ...... that contains column labels and conditional values

If you need to use a condition in a column more than once, you need to have multiple columns and conditions, and the condition is on the same line, which means that each condition is logically related to and(), and not in the same row, the relationship between or or ......

For example, if your data has data such as class name, grade, then your conditions should also be there.

Class, Name, Grade, and so on (of course you don't want to have a column as a filter can be without).

1 >=70 This filters out all the data for class 1 with a score greater than or equal to 70......

You need to experience the details yourself.

The Label Name of the Key Condition area must have ......

Specific analysis of specific problems, take the problem as the content (the subject of the email must contain "excel", I use this as the basis to identify non-spam, so as not to delete by mistake), excel sample file (please pay special attention: to the 03 version (if it is after 03, "save the file" as, the type box can choose 03), and the current situation and target effect are expressed) as an attachment to see it.

Leave an email and I'll send you a detailed example.

1. Automatic filtering: Open the **excel file that needs to be filtered, click on the cell with the mouse to locate any cell area containing data, and click the menu bar - data - filter - automatic filter.

2. Drop-down arrow: After selecting automatic filtering, the drop-down arrow appears in the data column, and click the drop-down arrow to display the filter menu. Each drop-down menu corresponds to a filter category.

3. Filtering method: Click on the number filter to filter the data for a specific data or a certain numerical interval for the ** file containing a large amount of data. For example, we need to filter out items with a historical score of less than 85 points, click on the number to filter, select less than, and enter 85 to filter.

4. Establish a region: If you want to screen out the scores of multiple categories, such as students with scores greater than 80 points in four subjects, we need to establish a conditional area in advance, and empty three or more rows above the overall data, corresponding to the input data classification and the required condition restrictions.

5. Advanced filtering: Click the menu bar - Data - Filter - Advanced Filter to open the menu of advanced filtering.

6. List area and condition area: After opening the advanced filter, you can enter the cell range or use the mouse to check the required area, and check the list area and the condition area respectively.

7. Result acquisition: If you need to let the filtered data be displayed elsewhere alone, check the box to copy the filtered results to other locations, and manually click the cells that need to be stored.

Click OK to get the filter results.

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.

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.

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.

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.

Open the excel file, open the excel file, enter the filter conditions in the blank space next to **, select the **data area and the first row label, and click [data]. Enter Advanced Filtering, click Advanced in the Sort & Filter tab, and click OK in the pop-up dialog box to enter Advanced Filtering.

Hello, the method is to create a data first in Excel, or copy a set of data from another place. In the ** data table in Excel, enter the data ** condition content, and enter the condition of showing 300 and consuming 20. As in the diagram, enter well.

The operation steps of Excel**Advanced Filtering are as follows: First, let's open Excel** on the computer desktop that needs to be filtered. Then, together we click on the data option in the ribbon at the top of the page.

Second, let's select the data that needs to be filtered.

Then select the ** you want to filter in the list area, remember to check the table header, and select the ** on the right in the condition area, which is the object you want to find, and finally copy to select the blank cell you want to copy. Finally, the point infiltration handicap is confirmed, and a screened ** is generated.

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.

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.