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

  • 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.

Related Posts:

  1. Conditional Formatting from another sheet
  2. Add a “sort” to a =QUERY statement in Google Spreadsheets
  3. How to use filter, map, and reduce in Python 3
  4. Excel to Google Sheets – Error: Formula parse error
  5. Angular map. What is it?
  6. Python pandas – filter rows after groupby
  7. Couchbase query using “\uefff” break the next conditional keys
  8. Give a value to an ng-model=”searchText” input based on list item clicked in Angular JS
  9. How to use searchFile and searchFolder at the same time correctly? – App Script
  10. How can I group data with an Angular filter?
  11. How to define global variable in Google Apps Script
  12. Google Spreadsheet adding tooltip
  13. How to label scatterplot points by name?
  14. .filter is not a function 
  15. First differences filter
  16. How to make wireshark filter POST-requests only?

Leave a Comment