"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
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