R1CI typre ref

[Balendra Kumar]

I am working on a model for my project The Data will be extracted from a data base

For the Project

I have to Do the Ranking for students for each class against there own class for whole school

It is not possible for me to put ranking formula for each class for the whole school

I I can get a Formula that can use a dinamic range for Ranking it will be halpfull

I would prefer if it is Excel formula

Regards
Balendra

 

[Andrew Poulsom]

Sorry, that's not at all clear, at least to me. The subject of your post doesn't seem to relate to the body. Please try again, giving sample data if you think it would help.

 

[Balendra Kumar]

Hi Andrew

Following is the Data

Class Marks Ranking
I A 25 8
I A 60 3
I A 35 7
I A 40 6
I A 51 5
I A 68 1
I A 54 4
I A 68 1
I B 15 6
I B 34 1
I B 25 3
I B 16 5
I B 24 4
I B 26 2
I c 25 10
I c 60 3
I c 35 7
I c 40 6
I c 51 5
I c 68 1
I c 54 4
I c 68 1
I c 15 14
I c 34 8
I c 25 10
I c 16 13
I c 24 12


Can i Use Class As a variable to decide about the ref in the Ranking formula
This way I can calculated the Ranking for all the students in a perticuler class against student for same class.

I woul like to add that the number of Students in as class can vary Also What if i want ot know that Last five stuents in the Class

I am sorry if i was not clear in my earlier Post.

Balendra

 

[Andrew Poulsom]

Try:

=SUMPRODUCT(--(A$2:A$28=A2),--(B$2:B$28>B2))+1

in C2 copied down.