Try this:

=IF(ISERR(SMALL(IF(MATCH(names,names,0)=ROW(INDIRE CT("1:"&ROWS(names))),ROW(INDIRECT("1:"&ROWS(names )))),ROWS($1:1))),"",INDEX(names,SMALL(IF(MATCH(na mes,names,0)=ROW(INDIRECT("1:"&ROWS(names))),ROW(I NDIRECT("1:"&ROWS(names)))),ROWS($1:1))))

ctrl+shift+enter, not just enter
copy down


"Tevuna" wrote:

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.