Brother it's same as i have calculated. Failed persons shouldn't be included while ranking. Rank should be assigned to the students who have given all the papers.
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...