One question to 0ne Consultant = only 1 answer (Either 1,2,3,4)..???

"AlexM" wrote in
message :



Baically, I have a worksheet with names of consultants in the first
column, and then question numbers at the top of the following columns.
Each question could have an answer of 1 - 4, grading the responses
given for service. 1 is excellent.

How do I find out how many 'excellents' a particular consultant has
received for a particular question? I have looked at Vlookup,
Getpivotdata and others, with no joy.


--
AlexM
------------------------------------------------------------------------
AlexM's Profile: http://www.excelforum.com/member.php...o&userid=34833
View this thread: http://www.excelforum.com/showthread...hreadid=545829