How to find duplicates within same column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank Beltre - 06 Sep 2007 19:09 GMT

Hello all,

I am trying to find if there are any duplicate values within the same
column, without removing them. Example

ID no.
1121
2222
3343
5554
6785
4565
6785
1121
3343

In this example 1121, 3343, 6785 are duplicates. I have a ~20000 rows
spreadsheet and would like to speed up the process.

Thank you all,

Frank

Reply to this Message

Peo Sjoblom - 06 Sep 2007 19:15 GMT

http://www.cpearson.com/excel/Duplicates.aspx

Signature

Regards,

Peo Sjoblom

> Hello all,
>
[quoted text clipped - 18 lines]
>
> Frank

Reply to this Message

Frank Beltre - 06 Sep 2007 21:12 GMT

Thank you! Good info.

Regards,

Frank

> http://www.cpearson.com/excel/Duplicates.aspx
>
[quoted text clipped - 20 lines]
>>
>> Frank

Reply to this Message