You could put this in a helper column next to your list and drag down.

=IF(COUNTIF($A$1:$A$100,A1)=1,A1,"")

Unique items will be listed in the helper column

Mike

"Martina" wrote:

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