This is my scenario:

I have a sheet with a e-mail field and another sheet with another e-mail
field (from different sources)

I want to know what (if any duplications exits), does anyone have any
suggestions how to do this in excel?

Thanks

One way: assume column A of sheets 1 & 2 contain your e-mail addresses then

In column B of Sheet1:

=COUNTIF(Sheet2!A:A,A1)

This will return 0 if no match found or 1 (or more) if one or matches are
found.

You could filter on 0

HTH

"Wayne Taylor" wrote:

This is my scenario:

I have a sheet with a e-mail field and another sheet with another e-mail
field (from different sources)

I want to know what (if any duplications exits), does anyone have any
suggestions how to do this in excel?

Thanks

Hi Toppers,

Thnaks for that, I've just had a quick play in a test spreeadsheet, I'll see
how it works on the real thing..

Thanks Very Much!

"Toppers" wrote:

One way: assume column A of sheets 1 & 2 contain your e-mail addresses then

In column B of Sheet1:

=COUNTIF(Sheet2!A:A,A1)

This will return 0 if no match found or 1 (or more) if one or matches are
found.

You could filter on 0

HTH

"Wayne Taylor" wrote:

This is my scenario:

I have a sheet with a e-mail field and another sheet with another e-mail
field (from different sources)

I want to know what (if any duplications exits), does anyone have any
suggestions how to do this in excel?

Thanks