I have a need to find out which Person has the highest number of reviews performed that found 1 defect
Sample data:
<tbody>
</tbody>
In the above, person 2 did 74 reviews that found 1 defect
Once I get the 74 review count, I plan to do an INDEX/MATCH to identify that it was Person 2
To get the 74 I tried this, but it didn't work
{=IF(B1:B11=1,MAX(C1:C11),0)}
Any suggestions on how to fix this?
Sample data:
Column A (Person) | Column B (Defects Found) | Column C (Reviews Performed) | |
1 | 1 | 0 | 65 |
2 | 1 | 1 | 42 |
3 | 1 | 2 | 85 |
4 | 1 | 4 | 54 |
5 | 2 | 0 | 25 |
6 | 2 | 1 | 74 |
7 | 2 | 3 | 45 |
8 | 3 | 1 | 108 |
9 | 3 | 3 | 15 |
10 | 3 | 5 | 85 |
11 | 4 | 1 | 49 |
<tbody>
</tbody>
In the above, person 2 did 74 reviews that found 1 defect
Once I get the 74 review count, I plan to do an INDEX/MATCH to identify that it was Person 2
To get the 74 I tried this, but it didn't work
{=IF(B1:B11=1,MAX(C1:C11),0)}
Any suggestions on how to fix this?