Hi 
I want to find out the email addresses in a file which are not in a specific other file (csv, ods, odt, one of these would be enough for me as I can convert them easily).
Maybe if I copy the column with all email addresses from 2.ods in a new sheet in 1.ods. And then use a formula in colum C with =IF(NOT(ISERROR(SEARCH(A$16:A$18;B$16:B$18))))
But this gives false even when A18 and B17 are the same.
Happy about a good and understandable solution.
Blessings, Klaus