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