# How to give a students two ranks

Ask a question Fayyaz295 3Posts Friday September 29, 2017Registration date October 13, 2017 Last seen - Last answered on Oct 13, 2017 at 10:20 AM by Fayyaz295
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
+0
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?

Have FUN!
+0
ac3mark 8020Posts Monday June 3, 2013Registration date ModeratorStatus October 22, 2017 Last seen -
Nope!
Fayyaz295 3Posts Friday September 29, 2017Registration date October 13, 2017 Last seen -
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.