Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Grade sorted base on Score

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  2. #2
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    TQ Yogi Anand, It's work very nicely.

    Thanks again.. your'e very clever person.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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