Compare Columns to find Duplicates

[dygitaldude]

Hello all,

I have a list with names of individuals and repeat addresses. I would like to find a way Duplicates. Thanks in advance.

1	A	B	C
2	John Smith	2 Main St	Apt 5B	Duplicate
3	John Smith	2 Main St	Apt 5B	Duplicate
4	Jason Bourne	5 Rock Road	Apt 2B	Not Duplicate
5	Jason Bourne	6 Lake Dr	Apt 10B	Not Duplicate
6
7
8
9

<tbody>
</tbody>

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Joe4]

Put this is cell D1 and copy down for all rows:

=IF(COUNTIFS(A:A,A1,B:B,B1,C:C,C1)>1,"Duplicate","Not Duplicate")

 

[dygitaldude]

Mr. Joe4

Although it is using a lot of resources (i.e taking bit of time when running over 14k rows) it worked perfectly. My sincere gratitude for taking time and providing solution. You are a champ!!

 

[Joe4]

You are welcome.

You might be able to get it to run a little faster by putting in the exact range references instead of the whole column, i.e.

=IF(COUNTIFS([COLOR=#ff0000]$A$1:$A$15000[/COLOR],A1,[COLOR=#ff0000]$B$1:$B$15000[/COLOR],B1,[COLOR=#ff0000]$C$1:$C$15000[/COLOR],C1)>1,"Duplicate","Not Duplicate")