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...