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

The filter feature in Excel won't allow you to do OR logic between columns, however, you can if you allow assistance from a formula.

I want to filter all rows where Category is equal to 1 OR Size is equal to A, the formula in E3 is:


Alternative formula:


Copy the formula and paste to cells below.

Now it is time to apply a filter to your data set. Go to tab "Data" on the ribbon, press with left mouse button on "Filter" button or press CTRL + SHIFT + L.

Arrows appear on your headers, see picture below.

Press with mouse on the arrow next to "Formula" header and deselect 0 (zero). If you use the alternative formula, simply deselect False.

Press with left mouse button on "OK" button. Here is the filtered table.

To remove the filter simply press with left mouse button on the "Clear" button on the ribbon.