Google Sheets Tips

List if the website is included.

• =ARRAYFORMULA(IF( ISNUMBER(FIND("example.com", A2:A)), "Yes", "No"))

Now Filter Views can be used on that boolean column to only display rows that match.

A	B
URL	Internal Domain?
example.com	=ARRAYFORMULA(IF( ISNUMBER(FIND("example.com", A2:A)), "Yes", "No"))
otherwebsite

---

Filter in one list and not another.

• =filter('sheet_1'!A:A,isna(match('sheet_1'!A:A,'sheet_2'!A:A,0)))