Dupe check over more than one column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to check for dupes over more than one column?

First Last
Jorge Luis Menedez
Jorge Luis Menendez

I want to identify these as dupes.
 
One way ..

Assuming the table is in cols A and B, data from row2 down

Put
In C2: =TRIM(A2&" "&B2)
In D2: =IF(C2="","",IF(COUNTIF($C$2:C2,C2)>1,"X",""))

Select C2:D2 and copy down

Col D will flag duplicates with an "X"

Btw, presumed there was a typo in your posted line:
Jorge Luis Menedez
Click to expand...

should have read as:
Jorge Luis Menendez
Click to expand...
 
Back
Top