Duplicate entries in single column w/o sorting?
 

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?
--
Regards, SColdiron

Duplicate entries in single column w/o sorting?
 

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


--


Regards,


Peo Sjoblom



"scoldiron" wrote in message
...
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?
--
Regards, SColdiron

Duplicate entries in single column w/o sorting?
 

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

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

"scoldiron" wrote in message
...
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?
--
Regards, SColdiron