Adapted this from the information on cpearson's website above:

C1=COUNTIF($A$1:$A$10,$B1) then copy down to C10 (adjust range
references and such to your specific situation, of course)

This will count the number of times the value in B1 occurs in A1:A10.
If B1 isn't in A1:A10, it returns 0. You can enclose this formula in
an IF function if you want.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=381709