Hello,

I have in my spreadsheet as follows:

A B C
1 PO200
2 PO200
3. PO201
4. PO202
--------

Total Purchase order = 3

As you can see above the total is only 3 although thre are 4, because PO200
is only 1 for the same serial of characters

My question is what is the function in excel the can count for only
difference in characters in those cells.

Thanks in advance

--
H. Frank Situmorang