How to give a students two ranks

Closed
Fayyaz295 Posts 3 Registration date Friday 29 September 2017 Status Member Last seen 13 October 2017 - 29 Sep 2017 à 14:56
Fayyaz295 Posts 3 Registration date Friday 29 September 2017 Status Member Last seen 13 October 2017 - 13 Oct 2017 à 10:20
Dear sir, I have made a result sheet with ranks. I want to give a student two ranks one in his class and other in all sections. For example, if class 5 has three sections how would I get rank of a student in his class and in all three sections
Related:

2 responses

Blocked Profile
29 Sep 2017 à 18:50
That is simple, what is the scale of the RANK?

How are you already ranking them? Is it a 1-10? Is it 1-4? Is it A-F? Is it 1 of 58?

So let us know, so we can ask more questions about your homework.

Have FUN!
Fayyaz295 Posts 3 Registration date Friday 29 September 2017 Status Member Last seen 13 October 2017
30 Sep 2017 à 11:40
thanks for reply. can you please give me your Email address so that i can send you my file.
Blocked Profile
1 Oct 2017 à 21:48
Nope!
Fayyaz295 Posts 3 Registration date Friday 29 September 2017 Status Member Last seen 13 October 2017 > Blocked Profile
13 Oct 2017 à 10:20
i am using this formula for ranking =RANK(P3,$P$3:$P$53)
I want to rank the all students of stander 8 who are studying in 4 different classes. this formula is giving me rank of all listed students but i want ranks on the base individual classed too.
for example classes A,B,C,D have 10 students in each class of same stander. i wand rank of A,B.C,D separately and collectively.