How to Use the Double Filter in Excel to Filter Data by Multiple Criteria

The double filter is a powerful tool in Excel that allows you to filter data by multiple criteria. This can be useful for finding specific data points or for comparing different data sets.

In this article, we will show you how to use the double filter in Excel. We will start by explaining the basics of the double filter, and then we will show you how to use it to filter data by multiple criteria.

What is the Double Filter?

The double filter is a feature in Excel that allows you to filter data by two different criteria. For example, you could use the double filter to filter data by the product type and the salesperson.

To use the double filter, you first need to select the data that you want to filter. You can then use the Advanced Filter dialog box to specify the two criteria that you want to use.

How to Use the Double Filter in Excel

To use the double filter in Excel, follow these steps:

  1. Select the data that you want to filter.
  2. Go to the Data tab and click the Advanced Filter button.
  3. In the Advanced Filter dialog box, specify the two criteria that you want to use.

The data will now be filtered based on the two criteria that you specified.

Criteria

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

See also  How to Find Duplicates in Excel

Here are some examples of how you can use the double filter:

  • Filter data by product type and salesperson.
  • Filter data by date range and product type.
  • Filter data by sales amount and customer location.

How to create a filter using Advanced Filter?

Create the data and filter criteria:

double filter data table and criteria

Click the advanced:

double filter advanced filter button

Use the ranges as follows:

double filter advanced filter applied

Clicking ok will give the following results:

double filter data double filtered

Add more conditions for double filter like below and select the following ranges for criteria in advanced:

double filter advanced filter results

The results are as follows:

double filter data double filtered results