Dupe check over more than one column

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

should have read as:
> Jorge Luis Menendez

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Wynn" <[email protected]> wrote in message
news:[email protected]...
> 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.

Max, This is extremely helpful. Thank you very much. Wynn

"Max" wrote:

> 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
>
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
> "Wynn" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>

Glad to hear that, Wynn.
Thanks for the feedback.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Wynn" <[email protected]> wrote in message
news:[email protected]...
> Max, This is extremely helpful. Thank you very much. Wynn