How to give a students two ranks [Closed]

Report
Posts
3
Registration date
Friday September 29, 2017
Status
Member
Last seen
October 13, 2017
-
Posts
3
Registration date
Friday September 29, 2017
Status
Member
Last seen
October 13, 2017
-
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 replies


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!
Posts
3
Registration date
Friday September 29, 2017
Status
Member
Last seen
October 13, 2017

thanks for reply. can you please give me your Email address so that i can send you my file.
Blocked Profile
Nope!
Posts
3
Registration date
Friday September 29, 2017
Status
Member
Last seen
October 13, 2017
> Blocked Profile
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!