Some friends now often use Excel software at work, but some friends still don’t know how to use advanced filtering to implement queries with multiple conditions, so the editor below brings a simple tutorial on using advanced filtering to implement queries with multiple conditions in Excel. Let’s take a look!
The picture below is an employee information table. There are employees with the same names in different departments. There are people named Li Na in the Finance Department and the Information Department, and there are people named Zhang Min in the Finance Department and the Quality Assurance Department.
Now we can query the employee’s place of origin and basic salary based on the two conditions of name and department.
Seeing this, I guess the function masters must be thinking about how to write a long list of formulas. In fact, you can query with multiple conditions without formulas. Next, let’s take a look at the specific operation methods:
Click any cell in the data area, then click [Data], [Advanced].
In the [Advanced Filtering] dialog box, the list area will be automatically selected, so you don’t need to worry about it here.
Set filter conditions below:
【Condition area】Select H1:I4, which is the two known conditions of name and department.
【Copy to】Select J1:K1, which is the two items of place of origin and basic salary to be queried.
Click [OK], OK. Even if there are multiple names with the same name, the correct result can be returned.
There are three issues to note when using this method:
First, the titles of the data list area and the condition area must be the same.
Second, in the condition area, the order of the names must be consistent with the order in the data list area, and the data can be sorted if necessary.
Third, this method cannot automatically update as the data changes, which is a bit of a fly in the ointment.
OK, now you can see that in fact, to achieve many effects, you don’t need formulas to complete them.
The above has explained the simple operation content of using advanced filtering to implement queries with multiple conditions in Excel. I hope friends in need can learn it.
