How to filter Google Sheets by multiple contains using AND
Web Applications Asked on January 17, 2021
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.
2 Answers
Update based on your comment:
Use this as a custom filter formula:
=REGEXMATCH(F2,"(?i)Amazon.*Twitter|Twitter.*Amazon")
As a google sheets formula:
=FILTER(F2:F,REGEXMATCH(F2:F,"(?i)Amazon.*Twitter|Twitter.*Amazon"))
Answered by Marios on January 17, 2021
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.
Answered by Erik Tyler on January 17, 2021
Add your own answers!
Ask a Question
Get help from others!
Recent Questions
- How can I transform graph image into a tikzpicture LaTeX code?
- How Do I Get The Ifruit App Off Of Gta 5 / Grand Theft Auto 5
- Iv’e designed a space elevator using a series of lasers. do you know anybody i could submit the designs too that could manufacture the concept and put it to use
- Need help finding a book. Female OP protagonist, magic
- Why is the WWF pending games (“Your turn”) area replaced w/ a column of “Bonus & Reward”gift boxes?
Recent Answers
- haakon.io on Why fry rice before boiling?
- Peter Machado on Why fry rice before boiling?
- Joshua Engel on Why fry rice before boiling?
- Lex on Does Google Analytics track 404 page responses as valid page views?
- Jon Church on Why fry rice before boiling?