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:

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:

double filter data table and criteria

Let us click the advanced:

double filter advanced filter button

And use the ranges as follows:

double filter advanced filter applied

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

double filter data double filtered

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:

double filter advanced filter results

The results are as follows:

Type

Salesperson

Sales

Produce

Davolio

$6,544

Produce

Davolio

$2,000


Please check:

double filter data double filtered results

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:

  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".