Thanks:  0
Likes:  0

1. "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:
allen 56
Smith 78
Linda 34
Cerry 90
Mat 45

How to calculate/sort the grade based on score. TQ.

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 ]

2. 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:
allen 56
Smith 78
Linda 34
Cerry 90
Mat 45

How to calculate/sort the grade based on score. TQ.

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 ]

3. TQ Yogi Anand, It's work very nicely.

Thanks again.. your'e very clever person.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•