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

[inJesus]

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

[inJesus]

I have also asked in http://forums.linuxmint.com/viewtopic.php?f=47&t=275497&p=1511255#p1511255 and could work with the answer.