how do i show non-unique records (duplicates) using advanced filte
Marty,
I would use a helper column, with a formula like
=COUNTIF(A:A,A2)
copied down, then filter on that column, for values 1.
HTH,
Bernie
MS Excel MVP
"Marty" wrote in message
...
i want to show the duplicates and hide the unique records. advanced filter
works great when selecting "unique records only", but i want the opposite
result. any ideas on how to accomplish this using the filter or VBA would be
great!
Thanks!
|