Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Question
I need a count of features that have equal values and separated by who have the equal values. test1 Dan 7 Brian 1 test2 Dan 3 Brian 3 test3 Fred 3 Dan 1 test4 Mike 3 Brian 3 i.e. how many times did each person have the same score as another person? Thanks in advance! Dan -- pfeff ------------------------------------------------------------------------ pfeff's Profile: http://www.excelforum.com/member.php...o&userid=29858 View this thread: http://www.excelforum.com/showthread...hreadid=495604 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Question
Assuming these are in 5 separate columns:
=SUMPRODUCT(--(C1:C100=E1:E100),--(C1:C100<"")) In article , pfeff wrote: I need a count of features that have equal values and separated by who have the equal values. test1 Dan 7 Brian 1 test2 Dan 3 Brian 3 test3 Fred 3 Dan 1 test4 Mike 3 Brian 3 i.e. how many times did each person have the same score as another person? Thanks in advance! Dan |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Question
Thanks JE! Does the same idea apply if I want to find out if score a is higher than score b? Dan -- pfeff ------------------------------------------------------------------------ pfeff's Profile: http://www.excelforum.com/member.php...o&userid=29858 View this thread: http://www.excelforum.com/showthread...hreadid=495604 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Question
I got it all to work. Many thanks and to all and have a safe and happy holiday season! -- pfeff ------------------------------------------------------------------------ pfeff's Profile: http://www.excelforum.com/member.php...o&userid=29858 View this thread: http://www.excelforum.com/showthread...hreadid=495604 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a question regarding countif formula. | Excel Worksheet Functions | |||
countif question using 2 conditions | Excel Worksheet Functions | |||
Question on Conditional COUNTIF | Excel Worksheet Functions | |||
COUNTIF Question | Excel Worksheet Functions | |||
COUNTIF Question | Excel Worksheet Functions |