If you want to use a formula:

try this:
=COUNTIF(A1:A10,"BOB")
or
=COUNTIF(A1:A10,"*BOB*")

(adjust the range references to suit your situation)

You could also us a Pivot Table

Does that help?
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=487412