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
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Oct 27, 2010 at 06:39 PM
Related:
- Duplicate emails in two columns
- Display two columns in data validation list but return only one - Guide
- How to stop postmaster emails - Guide
- Outlook duplicate items remover (odir) - Download - Email
- How to refresh outlook emails - Guide
- Tweetdeck larger columns - Guide
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
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")
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")