In C1:
=IF(ROW()COUNT(E:E),"",INDEX(A:A,SMALL(E:E,ROW()) ))
Select B1:C1, copy down to the max expected extent of data in col A. Hide
away col B. Col C returns the list of uniques in col A, with results
neatly
bunched at the top.
--
Max
Singapore

Hi Max,

Typo...? Should maybe be

In C1:
=IF(ROW()COUNT(B:B),"",INDEX(A:A,SMALL(B:B,ROW()) ))

Regards
Martin