How to find the rank of only passed students.
Here is a part of Mark sheet I prepared.
I need to find the rank of only passed students.
That means, in my problem,
ABC should get 2
DEF should get 0 or "FAIL" or "No Rank"
GHI should get 3
and JKL should get 1
In this problem, there is no incidence of tie. But, in my real problem, there can occur tie. And, for tie, the rank version of 1, 2, 3, 3, 5, 6 is okay.
<tbody>
</tbody>
Thanks in advance.
Here is a part of Mark sheet I prepared.
I need to find the rank of only passed students.
That means, in my problem,
ABC should get 2
DEF should get 0 or "FAIL" or "No Rank"
GHI should get 3
and JKL should get 1
In this problem, there is no incidence of tie. But, in my real problem, there can occur tie. And, for tie, the rank version of 1, 2, 3, 3, 5, 6 is okay.
Name | Total | Result | Rank |
ABC | 89 | PASS | |
DEF | 45 | FAIL | |
GHI | 85 | PASS | |
JKL | 95 | PASS |
<tbody>
</tbody>
Thanks in advance.