Duplication in Column

Hello,

I have a column of names in the format FirstName LastName.
The column contains many thousands of rows of data.

What is the best way to find out what names have been duplicated in
the list?

Thanks in advance for your assistance.

Regards,
Ket
London

There may be easier/ faster ways, but I would insert a new column. In that column, add the formula = a2 & " " & b2 so that cell C2 is the full name "John Doe".

Then, sort by that column. Duplicates will appear together.

To make it easier to spot the duplicates, use conditional formatting to say: if C3 = C2, format this bright red with a yellow background. Copy that conditional formatting down the entire column.

Matt

Tag them


http://www.cpearson.com/excel/duplicat.htm

--

Regards,

Peo Sjoblom


"Ket" <ketkana@tiscali.co.uk> wrote in message
news:j06e21pnb52qhm60g8oc22inul8u9omlhs@4ax.com...
> Hello,
>
> I have a column of names in the format FirstName LastName.
> The column contains many thousands of rows of data.
>
> What is the best way to find out what names have been duplicated in
> the list?
>
> Thanks in advance for your assistance.
>
> Regards,
> Ket
> London

In an adjacent column, add

=IF(COUNTIF(A:A,A1)>1,"Duplicate","")

and copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ket" <ketkana@tiscali.co.uk> wrote in message
news:j06e21pnb52qhm60g8oc22inul8u9omlhs@4ax.com...
> Hello,
>
> I have a column of names in the format FirstName LastName.
> The column contains many thousands of rows of data.
>
> What is the best way to find out what names have been duplicated in
> the list?
>
> Thanks in advance for your assistance.
>
> Regards,
> Ket
> London