listing unique values

[AJSloss]

I have a column looking like this:
716h
(Blank)
711u
(Blank)
714h
(Blank)
714
(Blank)
716
711u
711
714
717
(Blank)
(Blank)
(Blank)

I used =SUMPRODUCT((B7:B22<>"")/COUNTIF(B7:B22, B7:B22&"")) to figure out
that there were 7 unique values, now i want to list what those seven are in
another column (preferably in numerical order, then alphabetical; 711, 711u,
714, 714h...)

 

[Dave Peterson]

This is not a formula, but you could use Data|Filter|Advanced filter (xl2003
menus).

You'll need a header for that column, too.

Debra Dalgleish describes it here:
http://contextures.com/xladvfilter01.html#FilterUR

Then you could sort this single column.