I'd use a helper column with a formula like:

=and(a2<"",countif(a:a,a2)=1)
and fill down

And filter on that helper column.

the-big-john wrote:

Is there anyway to filter using multiple criteria: nonblank AND unique?

--

Dave Peterson