Data=filter=Advanced filter and click the unique checkbox. This will show
you a list of uniques.

--
Regards,
Tom Ogilvy


"vrijbergen" wrote
in message ...

Hi,

I want to automatically filter out all non unique data from my Excel
column's. How do I do this? I already tried the data-filter function.

Thanks Michieol


--
vrijbergen
------------------------------------------------------------------------
vrijbergen's Profile:
http://www.excelforum.com/member.php...o&userid=27757
View this thread: http://www.excelforum.com/showthread...hreadid=472677