ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   listing unique values (https://www.excelbanter.com/excel-discussion-misc-queries/248104-listing-unique-values.html)

AJSloss

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

Dave Peterson

listing unique values
 
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


All times are GMT +1. The time now is 02:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com