count text occurences in a column

[Dave Peterson]

Insert a new column A--to hold the count. Now everything has shifted over one
column.

Put this in A1:

=SUMPRODUCT(
(LEN(C1:C10)-LEN(SUBSTITUTE(UPPER($c$1:$c$10),UPPER(b1),"")))/LEN(b1))


Adjust the range to match what's in column C.

And drag down column A until you're at the bottom (even with column B).

First apologies for new thread.
Second: yes i have a unique list. In column A is my unique list and in
column B (different length and width) is the list of entries I need counted.
SOme cells have multiple values from column A. So I need a final column C I
guess that shows the number of times an entry occurs fromthe list in column A
in column B.

I am not proficient enough to understnad your example. Sorry! I can use
MSN chat though! Pay!!! LOL....