View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AJSloss AJSloss is offline
external usenet poster
 
Posts: 13
Default listing unique values

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...)