How can I filter multiple words in a column? (for example, I want to filter the words golf and ski to show up in my filter)

enter image description here

2 Answers 2


You may use an additional column to filter categories in place. Here's the formula to check if any text matches "golf" or "ski" :


It will give True if cell A2 contains any word "golf" or "ski". If you want to check more then two words, the easy way is to write them into a separate list, say K1:K3:


and then use this formula join("|", K1:K3) will give text "golf|sky|badminton", so final check formula is:

=REGEXMATCH(A2, join("|", K1:K3))

where K1:K3 is list with desired text to match.


You should move your 3 unique sport values to 3 additional columns: Ski Badminton Golf

where you could filter any sport with values: true/false select

Cell formula for the additional columns:


my example additional hidden columns


Second solution -

Additional one column with unique left-column value and filter by search

I've publish my google sheet for details here

inline filter

  • But i have over 12 sports and another 15 different stuff to add to the category part. They should all be in the same column because they are a column. And the sports as well. Commented May 15, 2016 at 14:38
  • So either hidden additional column groups or transpon to additional table pp.vk.me/c631427/v631427840/2d574/tmtZKJW_dn0.jpg
    – Dek4nice
    Commented May 15, 2016 at 15:23
  • I've found another way. And I think this is the smallest workaround. (upd)
    – Dek4nice
    Commented May 15, 2016 at 16:07

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.