How To Use Double Filter

In this article we will try to learn how to use the double filter in Excel.

Let us try to create simple data in Excel for the filer criteria:

TypeSalespersonSales
BeveragesSuyama$5,122
MeatDavolio$450
produceBuchanan$6,328
ProduceDavolio$6,544
BeveragesSuyama$300
MeatDavolio$200
produceBuchanan$4,000
ProduceDavolio$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

 

Let us create the data and filter criteria:

data table and criteria

 

Let us click the advanced:

advanced filter button

 

And use the ranges as follows:

advanced filter applied

 

Clicking ok will give the following results:

TypeSalespersonSales
produceBuchanan$6,328
ProduceDavolio$6,544
BeveragesSuyama$300
MeatDavolio$200
produceBuchanan$4,000
ProduceDavolio$2,000

 

data double filtered

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

Criteria
TypeSalesperson
produceDavolio

 

And select the following ranges for criteria in advanced:

advanced filter results

The results are as follows:

TypeSalespersonSales
ProduceDavolio$6,544
ProduceDavolio$2,000

 

Please check:

data double filtered results

Adding one more condition:

TypeSalespersonSales
produceDavolio>200

 

The results are as follows:

TypeSalespersonSales
ProduceDavolio$6,544
ProduceDavolio$2,000

Template

You can download the Template here – Download