List unique values - non duplicates

The value list is placed in column A2:A100000 (A1 is the header)
Place the first formula in column B2 (B1 is the header) and copy down as far as needed.
Prerequsites: All cell-values are valid  (no "errors"), just to simplify.

Excel 2010-
=AGGREGATE(15;6;$A$2:$A$100000;ROW(A1))

Excel -2007
Alt.1: Dual cells, one Array formula in B3
B2: =SMALL($A$2:$A$100000;1)
B3: =SMALL(IF(($A$2:$A$100000-$B1)>0;$A$2:$A$100000);1)


Alt.2: Singel cell, Array formula
B2: =IF(ROWS($B$2:$B2)>1;SMALL(IF(($A$2:$A$100000-$B1)>0;$A$2:$A$100000);1);MIN($A$2:$A$100000))


Array formulas: The formulas with IF(..) has to be confirmed with Ctrl+Shift+Enter, not just Enter