We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

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

asked 2018-08-12 17:28:54 +0200

inJesus gravatar image

updated 2020-07-29 12:01:07 +0200

Alex Kemp gravatar image

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-08-12 21:19:59 +0200

inJesus gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-12 17:28:54 +0200

Seen: 121 times

Last updated: Aug 12 '18