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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]1
[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John Smith[/TD]
[TD]2 Main St[/TD]
[TD]Apt 5B[/TD]
[TD]Duplicate[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]John Smith[/TD]
[TD]2 Main St[/TD]
[TD]Apt 5B[/TD]
[TD]Duplicate[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Jason Bourne[/TD]
[TD]5 Rock Road[/TD]
[TD]Apt 2B[/TD]
[TD]Not Duplicate[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Jason Bourne[/TD]
[TD]6 Lake Dr[/TD]
[TD]Apt 10B[/TD]
[TD]Not Duplicate[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="width: 514"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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")