Filtering without redundancies


R

RedFive

I am trying to run a filter based on a certain column and need each value
represented only once. When I make a custom filter and check the unique
entries only, it doesn't do anything to the column. When I run an AutoFilter
it works but shows every instance for that value. Am I missing something?
 
Ad

Advertisements

D

Dave Peterson

I'd add an extra column with a formula like:

=countif(a$2:a2,a2)

Then I'd filter on this column first to show the 1's.
 
Ad

Advertisements

J

Joel

You can use AdvanceFilter but you have to selct only one column of data and
if you copy the data it has to be on the same owrksheet. Try from worksheet
menu

Data - filters - AdvanceFilter and check unique.

You can record a macro while manually performing the Advance Filter to get
the code for a macro.
 

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

Top