If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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...) |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|