How to find field entries in a column in 1.ods which are not in 2.ods?

Hi :slight_smile:

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

I have also asked in and could work with the answer.