G
Guest
In a list of numbers, I want to know which numbers appear more than once.
Any idea how to do this? I tried using Data>Filter>Advanced 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.
Any idea how to do this? I tried using Data>Filter>Advanced 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.