EXCEL, MULTI CRITERIA DATA FILTERING!

1.Open the file that needs to be filtered. The aim is to find out the data for wages of 2000 and reimbursement < 1000. If you choose to view them one by one, it is more inefficient, and if there is a lot of data, it will be even more difficult to find.

2.As shown in the figure, add the auxiliary condition area, and enter the formula, according to our requirements, enter the formula "=(c2>2000)*(d2<1000).", where C2 stands for "salary" and D2 stands for "reimbursement", and the conditions are selected according to your own needs in practice.

<>4.Select any cell, find the "Filter" column in "Data" in the toolbar, and select "Advanced".

<>6.In the "Condition area", select the auxiliary condition area created in step 2.

Enter in C1.

sumproduct((sheet1!$a$1:$a$100=a1)*(sheet1!$b$1:$b$100=b1)*sheet1!$c$1:$c$100)

Drag down. sheet1!$a$1:$a$100 represents the original data table Column A: Dimensions.

sheet1!$b$1: $b$100 represents the original data table Column B: Color.

sheet1!$c$1: $c$100 for **.

Note! The dimensions of the three columns must be the same, e.g. 1 to 100

The implementation method and detailed operation steps are as follows:

1. The first step is to open excel on the computer, and then enter some data and conditions in the form of **, see the figure below, go to the steps below.

2. Step 2, after completing the above steps, click the "Data" option in the toolbar, see the figure below, and go to the steps below.

3. Step 3, after completing the above steps, click on the "Advanced" option, see the image below, go to the steps below.

4. Fourth, after completing the above steps, click the reference symbol in the list area, then select the data area, click the reference symbol, see the figure below, go to the steps below.

5. Fifth, after completing the above steps, click the reference symbol in the inner area, then select the condition area, click the reference symbol, see the figure below, and go to the steps below.

6. Step 6, after completing the above steps, the result is as follows, only one student is eligible, see the figure below. In this way, the problem is solved.

For advanced filtering in Excel, if you want to meet multiple conditions in one column at the same time, when establishing the condition area, each condition of the same column is arranged horizontally, the first row is the column header, and the second row is the specified condition, as shown in the following figure, the data of column b "3 and < 10 is filtered

Note: 1. The horizontal arrangement of the condition area refers to the relationship between the conditions and the "and".

2. If there are multiple conditions in the same field name in the condition area, the relationship between the conditions is "or".

Which version of office software do you use, if it is 2007 and above version, your requirement is very easy to implement, if it is the 2003 version may be a little troublesome, the 2003 version should be in the "custom" filter to see, but at the same time meet 3 or more conditions to filter a little troublesome.

I think it's okay to use filtering, select data-filter-custom-condition selection, including ABC three drugs.

The condition column is written like this.

A1: Column name.

A2: A drug.

A3: B drug.

A4:C drug.

Excel Multiple Criteria Screening MethodExcel Multiple Criteria Screening Method and Companion One: Use Advanced Screening Multiple Conditions to Complete Multiple Condition Filtering The following figure is a two-permeable positive sheet worksheet, Table 1 is the data source, and Table 2 is as shown below.

Question 1: How to filter multiple conditions at the same time in excel 5 points Method 1: In the "Advanced" filter under the "Data" option, take the data region as the "list area", take the cell where the condition is located as the "condition area", check "Copy the filter result to another location", and specify a location, OK, you can.

Open the Excel that needs to be operated, hover over any cell in the column where the data needs to be filtered, find and click "Filter" in the data toolbar, and set the data filtering function for **.

Step 1: Open an Excel that needs to filter two columns of data at the same time. Step 2: Enter the criteria to be filtered in the blank field of ** (1 class, English greater than 90 points). Step 3: Select "Advanced Filtering" in the "Data" menu.

The steps to filter and set multiple conditions in excel are as follows: First, open the call that needs to be filtered. First of all, you need to filter out the staff whose salary is greater than 3000 and the expenditure is less than 500, then select any cell first, and enter =(d33000)*(e3500) in it.

Then click Enter.