In this article we will try to learn how to use the double filter in Excel.
Criteria
Let us try to create simple data in Excel for the filer criteria:
Type | Salesperson | Sales |
Beverages | Suyama | $5,122 |
Meat | Davolio | $450 |
produce | Buchanan | $6,328 |
Produce | Davolio | $6,544 |
Beverages | Suyama | $300 |
Meat | Davolio | $200 |
produce | Buchanan | $4,000 |
Produce | Davolio | $2,000 |
Now in order to filter it by a single criteria we can use the advanced filter with the following criteria:
Criteria |
Type |
produce |
How to create a filter using Advanced Filter?
Let us create the data and filter criteria:
Let us click the advanced:
And use the ranges as follows:
Clicking ok will give the following results:
Type | Salesperson | Sales |
produce | Buchanan | $6,328 |
Produce | Davolio | $6,544 |
Beverages | Suyama | $300 |
Meat | Davolio | $200 |
produce | Buchanan | $4,000 |
Produce | Davolio | $2,000 |
Now let us add more conditions for double filter like below:
Criteria | |
Type | Salesperson |
produce | Davolio |
And select the following ranges for criteria in advanced:
The results are as follows:
Type | Salesperson | Sales |
Produce | Davolio | $6,544 |
Produce | Davolio | $2,000 |
Please check:
Adding one more condition:
Type | Salesperson | Sales |
produce | Davolio | >200 |
The results are as follows:
Type | Salesperson | Sales |
Produce | Davolio | $6,544 |
Produce | Davolio | $2,000 |
How to create a filter using Filter Drop-Downs?
Follow these steps to apply a double filter using the filter drop-down menus:
- Select the data set that you want to filter.
- Go to the Data tab in the ribbon and click the "Sort & Filter" drop-down.
- Choose "Filter".
- Click the drop-down arrow for the first column you want to filter.
- Select the first criteria you want to use to filter the data.
- Repeat steps d and e for the second column you want to filter.
- The data will now be filtered based on both criteria, and only rows that meet both conditions will be displayed.
Note: In both methods, the double filter will only display the rows that meet both criteria, and the original data set remains unchanged. To remove the filter, go to the "Sort & Filter" drop-down and choose "Clear".