Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FINDING AND LISTING UNIQUE DATA IN A COLUMN | Excel Worksheet Functions | |||
Listing values minus the zero amounts | Excel Worksheet Functions | |||
listing unique entries from the entire worksheet | Excel Worksheet Functions | |||
various values and listing them | Excel Worksheet Functions | |||
Listing Unique Observations | Excel Worksheet Functions |