ExcelBanter - Filtering for Like Items in a Column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Filtering for Like Items in a Column (https://www.excelbanter.com/excel-discussion-misc-queries/132225-filtering-like-items-column.html)

Doug C

Filtering for Like Items in a Column

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

Teethless mama

Filtering for Like Items in a Column

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"

"Doug C" wrote:

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

All times are GMT +1. The time now is 05:39 PM.