Dear All,
I do have a sample data-set across A1:C8 as follows.
In Column D, I have put my desired result(conditional rank with multiple criteria).
In column E, I have tried to populate the result with Sumproduct function, but it is yielding 1,
Could someone help me in re-constructing the formula with SUmproduct.
My formula in E1=SUMPRODUCT(--($A$2:$A$8=A2),--($B$2:$B$8=B2),--(C2<$C$2:$C$8))+1
Pls help.
<tbody>
</tbody>
I do have a sample data-set across A1:C8 as follows.
In Column D, I have put my desired result(conditional rank with multiple criteria).
In column E, I have tried to populate the result with Sumproduct function, but it is yielding 1,
Could someone help me in re-constructing the formula with SUmproduct.
My formula in E1=SUMPRODUCT(--($A$2:$A$8=A2),--($B$2:$B$8=B2),--(C2<$C$2:$C$8))+1
Pls help.
Name | Department | Score | Rank-desired Result | Result With Sumproduct |
A | Science | 80 | 2 | 1 |
B | Science | 75 | 3 | 1 |
C | Science | 95 | 1 | 1 |
D | Commerce | 60 | 3 | 1 |
E | Commerce | 55 | 4 | 1 |
F | Commerce | 70 | 2 | 1 |
G | Commerce | 80 | 1 | 1 |
<tbody>
</tbody>