Grade sorted base on Score

[msmn]

"I am a teacher, and I use excel to do my score & grading, but I still have to manually sort the score in order to me to get the sorted grade. Please help.
For example:
Name Score Grade
allen 56
Smith 78
Linda 34
Cerry 90
Mat 45

How to calculate/sort the grade based on score. TQ.
It should be: (grade)

Name Score Grade
allen 56 3
Smith 78 2
Linda 34 5
Cerry 90 1
Mat 45 4


[ This Message was edited by: msmn on 2002-04-15 19:31 ]

[Yogi Anand]

On 2002-04-15 19:29, msmn wrote:
"I am a teacher, and I use excel to do my score & grading, but I still have to manually sort the score in order to me to get the sorted grade. Please help.
For example:
Name Score Grade
allen 56
Smith 78
Linda 34
Cerry 90
Mat 45

How to calculate/sort the grade based on score. TQ.
It should be: (grade)

Name Score Grade
allen 56 3
Smith 78 2
Linda 34 5
Cerry 90 1
Mat 45 4


[ This Message was edited by: msmn on 2002-04-15 19:31 ]

Hi msmn ... Welcome Teacher!
You want to use the Rank FUNCTION
Let us say scores for matt, allen, smith, and cerry are in cells B2:B5, then in cell C2, write the formula

=RANK(B2,$B$2:$B$5,0)
and replicate this in cells C3 through C5

You may also want to look at RANK FUNCTION in Excel Help.



_________________
Yogi Anand
Edit: Deleted reference to inactive web site from signature line

[ This Message was edited by: Yogi Anand on 2003-01-19 18:17 ]

[msmn]

TQ Yogi Anand, It's work very nicely.

Thanks again.. your'e very clever person.