Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
In a list of numbers, I want to know which numbers appear more than once.
Any idea how to do this? I tried using DataFilterAdvanced Filter, and then choosing unique records only, but that gives me a list of *all* the numbers, while deleting the duplicate instances of those that appear twice (or more; but I know they'd only appear twice). I need it the other way -- I need a list of *only* the numbers that appear more than once. Any ideas or help you can provide, I'd really appreciate it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to make Bullen's FilterCriteria() data refresh real-time? | Excel Discussion (Misc queries) | |||
Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
Pivot table and filter | New Users to Excel | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |