Duplicate entries in single column w/o sorting?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scoldiron - 07 May 2008 15:48 GMT

I am trying to find duplicate entries (text) in a single column without
sorting. The column is several hundred rows in length. Can someone help?

Signature

Regards, SColdiron

Reply to this Message

Peo Sjoblom - 07 May 2008 15:51 GMT

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

Signature

Regards,

Peo Sjoblom

>I am trying to find duplicate entries (text) in a single column without
> sorting. The column is several hundred rows in length. Can someone help?

Reply to this Message

Bernard Liengme - 07 May 2008 15:56 GMT

I will assume the text is in column A
A1 cannot be a duplicate - there is nothing above it
In A2 enter =IF(COUNTIF($A$1:A1,A2),"Duplicate","")
Copy this down the column (double click its fill handle)
All duplicates (text that appears for the second or subsequent time) will
show with Duplicate in B
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

>I am trying to find duplicate entries (text) in a single column without
> sorting. The column is several hundred rows in length. Can someone help?

Reply to this Message