vimal.ku2009
New member
Hello,
I was trying to find the rank of individuals but there are some students who are absent in some tests. I have to find the rank of other students excluding those who are absent. They should be shown as "FAIL".while running the RANK function it is taking consideration of the failed students also.
Please solve the issue. Taking into consideration that no more columns should be added. Rank should be calculated in Rank column only.
Please find the attachment.
I was trying to find the rank of individuals but there are some students who are absent in some tests. I have to find the rank of other students excluding those who are absent. They should be shown as "FAIL".while running the RANK function it is taking consideration of the failed students also.
Please solve the issue. Taking into consideration that no more columns should be added. Rank should be calculated in Rank column only.
Please find the attachment.