Previous Topic Next Topic

Duplicate emails in two columns

Solved/Closed
phil - 27 Oct 2010 à 08:23
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 - 27 Oct 2010 à 18:39
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

Réponse 1 / 1
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 26
27 Oct 2010 à 18:39
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")

Similar discussions

How to disable grouping messages by dates in Yahoo?
jamal9722060 -
T-Bird -

7 responses
Blocking Spam Email with No Sender
bbop -
NormireX -

5 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Create Duplicate Sheet
MAasifkhan -
PoulJ -

1 response