How to use double filter?

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:

Now in order to filter it by a single criteria we can use the advanced filter with the following criteria:

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:

Now let us add more conditions for double filter like below:

And select the following ranges for criteria in advanced:

The results are as follows:

Please check:

Adding one more condition:

The results are as follows:

How to create a filter using Filter Drop-Downs?

Follow these steps to apply a double filter using the filter drop-down menus:

1. Select the data set that you want to filter.
2. Go to the Data tab in the ribbon and click the "Sort & Filter" drop-down.
3. Choose "Filter".
4. Click the drop-down arrow for the first column you want to filter.
5. Select the first criteria you want to use to filter the data.
6. Repeat steps d and e for the second column you want to filter.
7. 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".