Try this:

=COUNTIF(A$1:A$100,B1)

Biff

"rob" wrote in message
...
Can someone help me with this?
I would like to put a function into a cell in column C that will take the
text that is entered in a cell in column B and see how often it appears in
column A, returning the result into the cell in column C.

Thanks in advance,
rob