Duplicate entries in single column w/o sorting?

S

scoldiron

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?
 
B

Bernard Liengme

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
 
Top