Another play to extract the uniques list using non-array formulas
Assuming records listed in A1 down
Put in B1:
=IF(A1="","",IF(COUNTIF($A$1:A1,A1)>1,"",ROW()))
Put in C1:
=IF(ISERROR(SMALL(B:B,ROWS($A$1:A1))),"",
INDEX(A:A,MATCH(SMALL(B:B,ROWS($A$1:A1)),B:B,0)))
Select B1:C1, copy down till the last row of data in col A
Col C will return the list of unique records in col A,
neatly bunched at the top