I would like Excel to AUTOMATICALLY give me in column B unique records from
column A

A B
1 Andrew Andrew
2 Andrew Louis
3 Louis
4 Andrew

Advanced filter doesn't refresh automatically.
I remember a user once outlined a formula on this forum, but I can't find it
now.