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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot sort a table containing text 5
Create a list of unique entries based on several columns 1
Duplicate entry in a column/row 14
Two columns followed by single page-width column on same page 0
complex sort search and replace macro 2
Duplicates 2
Randomize cells in single column 2
Deleting (almost) duplicates in Excel 3

Top