how do i show non-unique records (duplicates) using advanced filte

  • Thread starter Thread starter Marty
  • Start date Start date
M

Marty

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!
 
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
 
Thanks for the reply! I was hoping to avoid the helper column. Running the
advanced filter and selecting unique is exactly the way i want to go, only
opposite. if there is any way of doing this withou a helper column i would
prefer it, but i may be stretching. It just seems if the filter can be ran
from VBA and select unique that the opposite should be true.

Thanks Again!
 
Marty,

When you are using the unique items only option, you are not actually filtering to show items that
only appear once - it also shows items that appear multiple times, but only lists them once. So
there really is no 'reverse' of that.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unique Filter Code / Advanced Filter 1
pulling just unique records 4
Non unique records only 2
Delete duplicates based on time 2
advanced filter office 2007 1
How to delete duplicate record 2
countif - unique values only 8
Delete duplicate rows using macro recorder 1

Back
Top