Author: Oscar Cronquist Article last updated on February 12, 2018

The built-in filter feature in Excel is a powerful tool, however, it won't allow you to filter with OR logic between columns.

This is where the Advanced Filter comes into the picture. It lets you do that and I will show you how now.

Copy your table headers and paste them somewhere on your worksheet.

Type the criteria you want to use right below the new headers, each below the header you want to filter, see picture below.

Make sure the condition is the only one on each row.

Now it is time to start the Advanced Filter. Go to tab "Data" on the ribbon and click "Advanced Filter" button.

The "Advanced Filter" settings window appears.

Click on "List range:" field and select cell range B6:D13 (your data you want to filter).

Click on "Criteria range:" field and select cell range B2:D4 (your criteria you want to use).

Click OK button.

The blue rows to the left show you that you have applied a filter to your data.

To clear the filter simply click on the clear button on the ribbon tab "Data".

Download Excel *.xlsx file

How to filter with OR logic between columns.xlsx