Is it possible to identify potential duplicates in Excel and report on them?
See attahced
I have two columns, one with a contcat name and another with contact email address. A5 and A6 have similar names and the same email address in columb B. I would like my report to inidcate these as potential duplicates so that they can be looked into further and possibly merged
Perhaps:
=FILTER(A2:B6,COUNTIF(B2:B6,B2:B6)>1)
Last edited by CheeseSandwich; 07-14-2023 at 05:00 AM. Reason: Added file
If things don't change they stay the same
LOTS of ways... one is :
=IF(COUNTIF(B$2:B2,B2)>1,"Duplicate","")
copeid down
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
or (delete expected resultrs first, if any):
=IF(MAP(B2:B6,LAMBDA(x,COUNTIF(B2:x,x)))>1,"Duplicate","")
no copy/paste needed.
Another option, using conditional format
=COUNTIF($B:$B,$B1)>1
applied to $A:$B
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks