Advanced filtering of Chinese content conditions in worksheets, such as gender, male or female.

Tool: Excel 2007

Steps: 1. Open Excel 2007 and find the cell input condition first. For example, the condition for input is language"80.

2. Click on the data, and in the "Sort and Filter" click "Advanced", and the "Advanced Filtering" dialog box will pop up.

3. Select the entire transcript, and then select the conditions you just entered in the "Conditions Area".

4. Check "Copy filter results to other locations" and select a cell in the blank area. Then click OK. Finish.

First, the tool raw materials.

excel2007

Computer. Second, the method steps.

1. Start Excel2007, take the transcript as an example.

2. If you want to screen students with a score of 80 in Chinese, you should first find the cell and enter the condition Chinese >80.

3. Click Data, click Advanced in Sort & Filter, and the Advanced Filtering dialog box pops up.

4. In the list area, select the entire transcript and select the conditions you just entered in the conditions area.

5. Check Copy the filter results to another location, and select a cell in the blank area. Then click OK.

Tool: Office Excel 2007

Steps: If we want to filter students with a score of 80 in Chinese, we will first find the cell and enter the condition. Here it is important to note that the condition we enter is language >80

Click Data, and in Sort and Filter, click Advanced to bring up the Advanced Filtering dialog box.

Here in the "List Area", select the entire transcript.

Then, in the Condition area, select the input condition.

Check Copy filter results to another location to select a cell in an empty space. Click OK.

Method: 1. Start excel2007, and make a transcript in advance.

2. If you want to screen students with a score of 80 points in Chinese, you should first find a cell to enter the conditions. Here it should be noted that the input condition is language >80, here it is recommended to directly copy and paste the "language" cell of the original transcript, so that there will be no mistakes, if it is typed, it is possible to fail the screening.

3. Click on the data, and click "Advanced" in "Sort and Filter" to pop up the "Advanced Filtering" dialog box.

4. Here in the "List Area", select 5 in the original transcript, and then in the "Condition Area", we select 6 in the conditions we just entered, and you can select "Copy the filter result to another location", and select a cell in the blank area. Then click OK and you're done.

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.

How it works:

01Open the excel file.

02 Advanced Filter Criteria Area: Copy the title section in the Advanced Filter Criteria area. Let's set the condition to age 21 as an example, and enter the filter condition in the "Condition area", and the format of the input condition is: ="=21".

03Click on the data above and select Advanced in the filter.

04In the "Advanced Filtering" window, select "Copy Filtering Results to Other Locations".

05Click the zoom button on the right side of the "List Area".

06Click the zoom button on the right side of the "Condition Area" and select the Condition Area. (including the title bar)07Click the zoom button on the right side of "Copy to" and select the output area.

08Click OK. Just save it.

Take Office2007 as an example, select the ** that you want to filter. Then click Insert, there is a pivot table down arrow on the left side of the insert function box, select the pivot table, and then follow the items you want to filter and put them into the filter box. See screenshot.

In an empty space (starting with g1).

Copy your title.

Under Language & Mathematics, enter 80 (same line).

Change the line: Enter <80 (same line) under Maths and English

Take the above as a conditional area and you'll be fine.

Look at the picture and speak, in addition, your screening requirements are too unusual.

What you mean is probably to ask if the cell data is the result of the calculation of the formula, can you participate in the filtering, right?

Point menu,"Data-Filter-Auto-Filter"

A black inverted triangle will appear in each cell of the first row of the data region, which can be filtered by clicking on it.

The specific screening will be carried out according to your needs.

That's right, do it.

Set the Advanced Filter Criteria area:

Chinese Mathematics.

Note that the middle-sign is for the need to display the format here.

In this case, Point Data - Filtering - Advanced Filtering.

In the dialog box that pops up, select all your data in the list area.

Select the area you just set in the condition area.

Writing on different lines is or, and the same line is and.

Select an empty area as the conditional area.

In the first row, enter the three fields of gender, age, and type of work (these three are the title fields, which should be the same as those in your original data table).

Then in the second line, enter male, <35, electrician.

In the third line the input corresponds to the input female, electrician.

I've tried, and there is no problem.

Thank you on the second floor, maybe there is a problem with my **, how to get it, I redid a different table, just try it, thank you!

I also encountered the same situation, you can check if the condition is written incorrectly, I just wrote the wrong condition, missing a horizontal bar.

First, you need to enter two filters.

Gender Education level.

Male University. Then, advanced filtering, set the data region and filter conditions respectively, and copy the data to select A15

1. The problem is broken down into two conditions, the computer score is 85 or the English score is 85;

2. Establish two judgment logics according to the conditions of disassembly, when the value of cell b2 ="Computers"At the same time c2>85, or b2="English", c2>85 gives one result if the condition is true, and another result is given if it is false.

3. Copy the formula to all columns and filter out the values that are true.

4. The formula is: =if(or(and(b2="Computers",c2>85),and(b2="English",c2>85)),true,false)

1. First of all, you can use the function of advanced filtering in Excel to extract data that meets specific conditions, as shown in the figure below.

2. Secondly, find "Advanced" under "Data" in the menu bar and click to open the dialog box.

3. In the window, the "List Area" selects the original data source area, the "Condition Area" is the written condition, and the "Method" selects "Copy the filter result to other regions", and "Copy to" selects any blank cell.

4. Finally, click "OK" to see the filtered result data.

Like automatic filtering, advanced filtering is a filtering of a list of data. But it's more powerful than auto-filtering. Advanced filtering allows you to type your own criteria in the Conditions field on the worksheet.

In addition, advanced filtering can automatically store the filtered results in other locations on the worksheet.

When using advanced filtering, filter criteria in the location of an empty area.

The subject area must contain a title, and a filter condition must be placed below the title, which is the name of the field on which the filter is based, which must be the same as the title under the data area to be filtered. The condition is the description of the condition for this title, and the criteria area for advanced filtering has at least two lines.

When you set several conditions for several columns and only need to meet any of them, you need to place each condition on a different row under the corresponding heading. If there are several rows of conditions, they need to be calculated on a row-by-row basis.

Click the Advanced button in the Data ribbon to open the Advanced Filtering dialog box, select the Copy Filter Results to Other Locations radio box, select the area you want to filter in the List Area text box, or click the worksheet, and then drag the area out of the worksheet with the mouse.

Move the cursor to the Conditional Area text box, click the worksheet, and drag out the conditional area in the worksheet.

If you selected the Copy filter results to another location radio box in the dialog box, you also need to plot the area where the results are placed in the worksheet. When drawing, be sure to draw a large enough area based on the approximate number of results. Otherwise, a portion of the filtering results will be lost.

Click the OK button to close the dialog box.

Perform an advanced screening in the worksheet of Exercise 1 to screen out the drug with a score greater than 85 in computer or English, which requires a professional function to screen.

When using advanced filtering, you must create a filter area, assuming your ** data area is column A:D, and you have "computer" and "English" items in the first row header, you can use h1:i3 as the condition area.

In H1, enter Computer.

Enter English in i1.

Enter >=85 in h2

Enter >=85 in i3

Since the condition relationship used is "or", the condition should be separated from h2 and i3.

Finally, you can select the data region, press "Data Filtering Advanced Filtering", and specify the condition region as h1:i3 in the pop-up window, and OK.

1. In the following**, if you want to filter out the data with "Chinese", "Mathematics" and "English" scores above 90 points, you need to use the advanced filter function at this time.

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, in the red line box, and click the "Advanced" button in the toolbar of the "Data" menu. After this positioning, the program will automatically find the area you want to filter, 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 where you want to perform advanced filtering, and if you make a mistake, 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.

When using advanced filtering, you need to have three regions, a data region, a conditional region, and a result output area.

Enter the filter conditions in the "Condition area", and one of the effects is as follows: here you filter for "Male" for "Gender" and "Male" for Male between 23 and 27 years old. Note: When entering conditions, the format is [=.]"= entry"(excluding square brackets).

Switch to the "Data" tab and click the "Filter Advanced" button.

In the "Advanced Filtering" window that opens, select the "Copy the filter results to another location" item, and click the zoom button on the right of the "List Area" to select the data region, which needs to include the header part.

Click the zoom button to the right of the Conditional Area to select the conditional area, which includes the title bar section.

Click the zoom button to the right of "Copy to" to select the output area.

Finally, click the "OK" button to complete the data filtering operation.