Skip to content

Google Sheets Tips

bootstraponline edited this page Apr 8, 2014 · 14 revisions

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

Clone this wiki locally