Comparing Field Contents
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
|