First separate the values into two separate columns using:
Text to Columns

and then see Counting Distinct Entries In A Range in:

http://www.cpearson.com/excel/Duplicates.aspx
--
Gary''s Student - gsnu200801


"iksuinje" wrote:

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.