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:

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: