How do I filter view two columns OR instead of AND?

Question

In Google Sheets, I want to filter view my results so only rows with an "x" in column D AND/OR column E are shown. If I filter to show the columns with an "x" in them, it will only show rows with an "x" in column D AND column E.

How do I make it do AND/OR? When I click the filter button in the column it just asks me to select which entries I want to show.

Answer 1

• Click on Column D.
• On the menu click 'Data'.
• Select 'Create a filter'.
• Click the filter icon that appeared at the top of Column D.
• Select 'Filter by condition'.
• Click the 'None' box and scroll down to 'Custom formula is'.
• Select and enter =OR(D:D="x",E:E="x") in value or formula.
• Click OK.

Alternatively, you can create a new sheet and in A1 enter =FILTER(Sheet1!A:E,(Sheet1!D:D="x")+(Sheet1!E:E="x")). Adjust the columns as needed.