Use DataFilterAdvanced Filter, it has a uniques option.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Martina" wrote in message
...
Dear Experts,
I know how to filter a list of data for unique entries using the advanced
filter however I want to have it happen without user intervention.

Can I use an array formula to pick out unique entries from a predetermined
list and display them in adjacent columns?

regards
Martina