Duplicate emails in two columns

Solved/Closed
phil - Oct 27, 2010 at 08:23 AM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Oct 27, 2010 at 06:39 PM
Hello,

I have two rows of approximately 2000 email addresses, One from our Accounts package database, another from our website database. Can anyone tell me how to run a search to highlight any duplicate email addresses from either of by rows? Example below

Customer (a) Accounts email (B) Website email (C)
toys rus info@toysrus.com sales@tesko.com ****dup
tesko sales@tesko.com sales@menco.com
liddles info@liddles.com email@harvestor.com
aldy sales@aldy.com sales@aldy.com ****dup


for instance the search needs to highlight tesko & aldy email address, the email addresses are obvoulsly not on the same line as each other so do not match up easily

Please can someone help

Thanks


1 response

RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Oct 27, 2010 at 06:39 PM
By using a vlookup for both searches (B-->C and C-->B) you can find the dupes.
In D:=IF(ISNA(VLOOKUP($B2,$C$2:$C$5,1,FALSE))," ","DUP")
In E:=IF(ISNA(VLOOKUP($C2,$B$2:$B$5,1,FALSE))," ","DUP")
0