How can count the number of times part of person's name (either first or
last) in cell C84 appears in the range C84:D99? The following formula
doesn't do the trick. Any suggestions?
=COUNTIF(C84:D99,"C65")
--
JCH
------------------------------------------------------------------------
JCH's Profile:
http://www.excelforum.com/member.php...o&userid=24697
View this thread:
http://www.excelforum.com/showthread...hreadid=382651