I'm trying to filter multiple columns using this formula:

=OR(A:A="Text", B:B="Text")


How can I add more things to filter here? e.g.

=OR(A:A="Text 1","Text 2", B:B="Text 1", "Text 2")
  • Keep in mind that we can't see your spreadsheet. We don't know your end goal, your data, data types, international locale, sheet setup, ranges... really nothing. So while your generic example makes sense to you (who backed that example out of full knowledge of your spreadsheet), it doesn't tell those of us "out here" very much. What it does show is that you aren't using the OR function correctly (and likely would not use OR at all in what you're trying to do anyway). Please share a link to your spreadsheet (or to a copy of it), so that we can see the problem in context.
    – Erik Tyler
    Apr 8, 2022 at 16:59
  • In that spreadsheet, hand-enter a few examples of what you want a formula to return. Off to the side in some empty cells, explain how you determined what those results should be. Then the volunteer contributors here will have enough to begin offering suggested approaches for formulas that will return those results.
    – Erik Tyler
    Apr 8, 2022 at 17:00
  • THANKS SOOO MUCH Oren Pinsky
    – Matt
    Apr 10, 2022 at 19:31

1 Answer 1


Try something like this:

=OR(A:A="Text 1",A:A="Text 2", B:B="Text 1", B:B="Text 2")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.