I am trying to apply two filter functions in Google Spreadsheets:
Column (A) contains new data
Column (B) contains filter data, i.e. cells with text that should not be included in column C
Column (C) is the outcome, i.e. column A minus all the cell data in column B
I use this formula in column C:
It works well in the sense that it filters data (in this case e-mail addresses) that should not be included in column C. However, I would also like to be able to filter whole domains, i.e. if the domain example.com is listed in column B then all addresses from column A ending with example.com should be excluded from column C.
See example file I created: applying two filters
Anyone knows how to do this?