Dupe check over more than one column


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.
 
Ad

Advertisements

M

Max

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
should have read as:
Jorge Luis Menendez
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top