| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count the items in one column if another column is blank | Excel Worksheet Functions | |||
| filtering to show items in a listbox | Excel Discussion (Misc queries) | |||
| Need help filtering a date column | Excel Discussion (Misc queries) | |||
| Filtering numbers in a column? | Excel Worksheet Functions | |||
| trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
Linear Mode
