0

I've searched for something similar but couldn't quite duplicate based on some other posts.

Column F has data on which websites you have a login with.

Let's say

F2 = Amazon, Facebook, Google, Twitter

F3 = Amazon, Google, Twitter

F4 = Amazon, Netflix, HBO

I want to filter the column to show all records that contain BOTH Amazon AND Twitter. So, the filtered results should show only F2 and F3.

0
1

There are many ways to do this. For simplicity's sake, I recommend this:

=FILTER(F2:F,REGEXMATCH(F2:F,"Amazon"),REGEXMATCH(F2:F,"Twitter"))

It should be easy to understand and add to as needed.

3
  • How would I do this in the Filter by condition custom formula? – Craig Jan 12 at 2:51
  • Applied to F2:F, use this: =REGEXMATCH(F2:F,"Amazon")*REGEXMATCH(F2:F,"Twitter") – Erik Tyler Jan 12 at 4:37
  • Small error there. You only need this: =REGEXMATCH(F2,"Amazon")*REGEXMATCH(F2,"Twitter") – Erik Tyler Jan 12 at 10:23
0

Update based on your comment:

Use this as a custom filter formula:

=REGEXMATCH(F2,"(?i)Amazon.*Twitter|Twitter.*Amazon")

enter image description here

As a google sheets formula:

=FILTER(F2:F,REGEXMATCH(F2:F,"(?i)Amazon.*Twitter|Twitter.*Amazon"))

regex

2
  • How would I do this in the Filter by condition custom formula? – Craig Jan 12 at 2:51
  • @Craig see my updated answer. – soMario Jan 12 at 3:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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