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