How to give a students two ranks

Closed
Fayyaz295 Posts 3 Registration date Friday September 29, 2017 Status Member Last seen October 13, 2017 - Sep 29, 2017 at 02:56 PM
Fayyaz295 Posts 3 Registration date Friday September 29, 2017 Status Member Last seen October 13, 2017 - Oct 13, 2017 at 10:20 AM
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

2 responses

Blocked Profile
Sep 29, 2017 at 06:50 PM
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!
0
Fayyaz295 Posts 3 Registration date Friday September 29, 2017 Status Member Last seen October 13, 2017
Sep 30, 2017 at 11:40 AM
thanks for reply. can you please give me your Email address so that i can send you my file.
0
Blocked Profile
Oct 1, 2017 at 09:48 PM
Nope!
0
Fayyaz295 Posts 3 Registration date Friday September 29, 2017 Status Member Last seen October 13, 2017 > Blocked Profile
Oct 13, 2017 at 10:20 AM
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.
0