Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to pick out unique components in a list with unique and common
Hi,
I want to pick out unique components in a cell which has both unique and common components. My data list is as follows. 514/406 514/326 7/571 7/310 48/570 514/311 48/305 7/21 600/571 .. .. As you see, each cell has tow components "first/second". I want to pick out unique "first" and count cells which has the same "first". For example using the above list, what I want is as follows. unique count 514 3 7 3 48 2 600 1 what I did is pick up the unique "first" by my own observation, and then use 'countif' to count the numbers using a certain trick such as 514/*, 7/*... thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
Identify & List unique values from a list using functions/formulas | Excel Worksheet Functions | |||
unique filter results in some non-unique records. | Excel Discussion (Misc queries) | |||
Compare multiple column of data and list out common and unique component in adj columns | Excel Worksheet Functions | |||
Count unique alpha numeric "characters" in a common cell | Excel Worksheet Functions |