Menu
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.
761
Answer: You can filter multiple columns based on 3 or more criteria by applying an advanced filter. To do this, open your Excel spreadsheet so that the data you wish to filter is visible. We've entered these values into columns F and G. Highlight the data that you wish to filter.
Enter this formula: =ISERROR(MATCH("Helen",A2:C2,0)) into cell D2, and then drag the fill handle down to the cells to apply this formula, and the FALSE and TRUE displayed into the cells, see screenshot: Note: In the above formula: “Helen” is the criteria that you want to filter rows based on, A2:C2 is the row data.
=OR(D:D="x",E:E="x") in value or formula.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.
95
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
