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


"Marty" <(E-Mail Removed)> wrote in message
news:0CB10BBF-B40F-4E84-8217-(E-Mail Removed)...
>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!

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!

"Bernie Deitrick" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:0CB10BBF-B40F-4E84-8217-(E-Mail Removed)...
> >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,

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


"Marty" <(E-Mail Removed)> wrote in message
news:7EFED2BE-58F9-495B-8D88-(E-Mail Removed)...
> 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!
>
> "Bernie Deitrick" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:0CB10BBF-B40F-4E84-8217-(E-Mail Removed)...
>> >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!
>>
>>
>>