How To Use Double Filter

How To Use Double Filter

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:

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:

Template

Further reading: 
Basic concepts 
Getting started with Excel
Cell References