Please help with Excel advanced filter questions

1. Complete with advanced filtering.

1. Enter the following content into cells H1 to K3:

Mathematics, Chinese, English, Physics.

Note: Two <60 in H3 and K3 cells) respectively

2. Select the original data range (A1:F13), click "Data"->Filter"->Advanced Filtering", the content of "Data Region" has been automatically filled in as "$a$1:$f$13", check "Copy the filter result to another location", and the conditional area can be selected with the mouse or directly enter "$h$1:".

k$3", "Copy to", fill in the content "$a$21:$f$33", and click "OK".

Second, it is done with functions.

1. Enter the formula in cell G2:

if(and(c2>90,d2>90,e2>90,f2>90),"All four subjects were above 90 points",if(and(c2<60,f2<60),"Less than 60 points in Mathematics and Physics",""))

Copy the formula down to the corresponding cell.

2. The selected tables are sorted in descending order by G column.

Student ID: Name: Mathematics, Chinese, English, Physics.

Filter with advanced level. Select your ** in the data area, and select the above conditions in the condition area (enter the above content into excel), which means that the records with less than or equal to 60 points in mathematics and language are filtered. According to yours, if you want to filter for more than 90 points, just enter the corresponding conditions.

I'm sure you'll use advanced filtering, don't be wordy.

The conditional locale is set as follows:

Mathematics, Chinese, English, Physics.

How does Microsoft Excel 2010 perform advanced insulator filtering? Advanced filtering is actually easy and simple. Today, I'm going to teach you how to do advanced filtering in Excel2010.

The steps for advanced filtering in Excel 2010 are as follows:

A data-complete worksheet.

Write down the criteria you want to filter under the valid data for your work.

In the Ribbon, select the Data tab, and in the Data tab, click Advanced.

At this point, a tab will pop up.

Drag the selection list area with the mouse, which is a1:f16 in high acres.

Drag the mouse to select the condition area, here C19:D20.

Click OK to view the filtered data.

The advanced filtering operation in Excel is as follows:

Operating environment: Lenovo YOGA14C, Windows11, Excel2021, etc.

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

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

Please click Enter a description.

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

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

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

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

The steps for Excel** advanced filtering are as follows:

Operating environment: ASUS X550JX, Windows 7, Microsoft Excel Worksheet 2013.

1. First of all, let's open the excel** that needs to be filtered on the computer desktop.

2. Then, let's click on the data option in the ribbon at the top of the page.

3. For its imitation times, let's select the data that needs to be screened by the bank's big search.

4. Next, we click the filter button in the data column above.

5. Then, we can click the drop-down button of the data that needs to be filtered.

In Excel, advanced filtering allows you to filter your data using multiple criteria. To use advanced filtering, follow these steps:

First, select the data region you want to filter on.

On the Data tab, click Filter.

On the header row of the data region, click the column header that you want to use as a filter. This displays a drop-down menu for that column.

On the drop-down menu, click Advanced Filtering.

In the Advanced Filtering dialog box, you can use drop-down menus and text boxes to set filter criteria. You can also use logical operators, such as AND or OR, to combine multiple conditions.

Click OK to start filtering the data.

If you want to clear the filtering, click the column header again, and then click All on the drop-down menu.

In Excel, the advanced filtering feature allows you to slide through your data using multiple criteria. To use advanced filtering, follow these steps:

First, select the data region you want to filter on.

On the Data tab, click Filter.

On the header row of the data region, click the column header that you want to use as a filter. This displays a drop-down menu for that column.

On the drop-down menu, click Advanced Filtering.

In the Advanced Filtering dialog box, you can use the drop-down slide menu and text box to set the filter criteria. You can also use logical operators, such as "and" or "or", to combine multiple conditions for letter splitting.

Click OK to start filtering the data.

If you want to clear the filtering, click the column header again, and then click All on the drop-down menu.

Excel enables the method of advanced imitation filtering as follows:

1.Click Data, and then click Advanced Options.

2.The Advanced Sieve Roll Selection dialog box pops up. If you first position the cursor in an area with data, the List Area box will automatically identify all addresses in the data area.

You can also bring up this dialog box first, and then select the data region address via the List Area box.

Filter by:1The filter results are displayed in the original area.

This simple understanding is the same as filtering, after the execution, the filtering results are displayed in the original data area, and those that meet the conditions are displayed, and those that do not meet the conditions are hidden.

2.Copy the filter results to a different location.

This is probably something that many users will use. In practice, the user needs to copy the filter results and copy them to the specified place. In filtering, the first thing is to perform the filter, then copy and paste. <>