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