Need comparison for similar email addresses separate columns

[DanaHoff]

G'Day to the List

Have an Excel 2010 spreadsheet with 902 email addresses in one column, and 927 email addresses in other column, sorted in alphabetical order.

Overview: Organization database has 902 Members (some have 2 email addresses subscribed to listserv) and Organizational Listserv which has all 927 (Difference is numbers are some members have 2 email addresses subscribed) BUT 902 of emails should be the same

Objective to compare Listserv Members 927 with Database Members 902. I am trying to isolate the email addresses which do NOT exist in Listserv Column, or who do not exist in Database Column for Audit purposes. All Members from the Database column should be subscribed or entered into the Listserv column.

If it's a perfect world the 902 email addresses will all be exactly the same as 902 out of the 927 Listserv email addresses.
Trying to highlight or sort and put identical email addresses on same line or using Conditionally formatting? Highlight Cell Rules/Duplicate cell rules Even when same email addresses are on the same row conditional formatting does not recognize them.
Thanks in advance. I can provide sample if necessary.
Thanks in advance
D

[etaf]

use
=countif(range of Listserv Members 927, cell of 1st Database Members 902 ) >1
that will highlight where the email address is the same

so if the Listserv Members 927 where in column A starting in row 2
and the 1st Database Members 902 in column B starting in row 2

=countif( $A$2:$A$1000, $B2) >1
and apply to A:B
should give you the highlight

otherwise perhaps you could attach a sample spreadsheet with some made up emails

[FDibbins]

CF highlight duplicates works within 1 column, not across 2 columns

We have a dilema here now. We discourage uploading personal info, but asking for a sample would be doing exactly that. Without seeing a few samples it's hard to say what we would beed to do to ID similar email addy's. Can you provide a few mocked up samples so we can see what differences to look for?

[DanaHoff]

Thanks for both replies. I've attached a sample worksheet with redactions and replacements to conceal
personal data.

Your help and assistance is greatly appreciated. Please keep in mind I'm novice Excel 10 user. Thanks again.
d

[FDibbins]

Your Listserv entries have trailing spaces, so I used a helper to remove them - and used the helper for teh calcs.

See if the attached will help you?