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 he
http://contextures.com/xladvfilter01.html#FilterUR
Then you could sort this single column.
AJSloss wrote:
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