Count for the same serial of characters
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
|