View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pfeff
 
Posts: n/a
Default Countif Question


It didn't quite work they way I wanted it, I should probably explain
better. I need it to keep track of the scores by person. So I would
need to know how many times the scores matched. My array is below...

Col A Col B Col C Col D Col E
Test1 Dan 7 Brian 1
Test2 Dan 3 Brian 3
Test3 Brian 3 Dan 1
Test4 Dan 5 Brian 3
Test5 Mike 4 Phil 1
Test6 Ed 3 John 7


--
pfeff
------------------------------------------------------------------------
pfeff's Profile: http://www.excelforum.com/member.php...o&userid=29858
View this thread: http://www.excelforum.com/showthread...hreadid=495604