Filtering for Like Items in a Column

G

Guest

Please help! Excel newbie. How can I search a column of part numbers, finding
duplicates, and display part numbers are duplicated? I have played with
advanced filter, but can only seem to filter out the dulicates, not filter
out what is not duplicated.

Thanks
 
G

Guest

Create a helper Column B

In B2: =IF(COUNTIF($A$2:$A$100,A2)>1,"Duplicated","OK")
Drag to copy as far as needed

Adjust to suit
AutoFilter the "OK"
 

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

compare data in column A with column B to find duplicates 8
How can I get rid of duplicates in a column? 2
Compare Figures in a Column 2
Filtering columns independently 4
advanced filtering multiple criteria 2
Excel 2002 - Filtering numbers 2
Duplicated Names In List 1
Filter Question 1

Top