How to Filter Multiple Columns in Excel (With Example)


The easiest way to filter multiple columns in Excel is to use the Advanced Filter function.

The following examples show how to use this function in two different scenarios:

  • Filter for rows that meet multiple conditions
  • Filter for rows that meet one of multiple conditions

Example 1: Filter for Rows that Meet Multiple Conditions

Suppose we have the following dataset that shows the total sales of certain products in certain regions for a company:

Now suppose we’d like to filter for rows where the Region is East and the Product is A.

To do so, we can define the following range of cells that contains our criteria:

Next, we can click the Data tab and then click the Advanced Filter button:

We’ll choose A1:C17 as the list range and F1:G2 as the criteria range:

Once we click OK, the dataset will be filtered to only show rows where the Region is East and the Product is A:

Example 2: Filter for Rows that Meet One of Multiple Conditions

Suppose we have the following dataset that shows the total sales of certain products in certain regions for a company:

Now suppose we’d like to filter for rows where the Region is East or the Product is A.

To do so, we can define the following range of cells that contains our criteria:

Next, we can click the Data tab and then click the Advanced Filter button.

We’ll choose A1:C17 as the list range and F1:G3 as the criteria range:

Once we click OK, the dataset will be filtered to only show rows where the Region is East or the Product is A:

Additional Resources

The following tutorials explain how to perform other common operations in Excel:

How to Sum Filtered Rows in Excel
How to Delete Filtered Rows in Excel

Leave a Reply

Your email address will not be published.