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?
--
RedFive

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.

RedFive wrote:

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?
--
RedFive

--

Dave Peterson

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.

"RedFive" wrote:

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?
--
RedFive