+ Reply to Thread
Results 1 to 4 of 4

[Help] Rank From Lowest to highest

  1. #1
    Registered User
    Join Date
    05-28-2015
    Location
    philippines
    MS-Off Ver
    ms 2007
    Posts
    11

    [Help] Rank From Lowest to highest

    This code rank the student grades from highest to lowest , My problem is i want to get the reverse of this code that will rank the grades of the students from lowest to highest just like the picture shown. Can anyone help me to solve this. file was attached with the expected result. thanks.

    Please Login or Register  to view this content.
    lowest.jpg
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: [Help] Rank From Lowest to highest

    Try this
    Please Login or Register  to view this content.
    Same formula slightly changed.

  3. #3
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: [Help] Rank From Lowest to highest

    this part :

    =RANK(F15,$F$15:$F$29)..........

    change

    =RANK(F15,$F$15:$F$24,1).........

    then it reverse

    so complete formula:
    =RANK(F15,$F$15:$F$24,1)+(COUNT($F$15:$F$24)+1-RANK(F15,$F$15:$F$24,0)-RANK(F15,$F$15:$F$24,1))/2

  4. #4
    Registered User
    Join Date
    05-28-2015
    Location
    philippines
    MS-Off Ver
    ms 2007
    Posts
    11

    Re: [Help] Rank From Lowest to highest

    Quote Originally Posted by kvsrinivasamurthy View Post
    Try this
    Please Login or Register  to view this content.
    Same formula slightly changed.
    Thank you so much mate.. Solved

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Rank Data from Highest to lowest using a macro
    By tejboyd in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-28-2015, 07:20 AM
  2. Rank from highest to lowest
    By mastertonn in forum Excel General
    Replies: 7
    Last Post: 07-31-2014, 12:57 PM
  3. [SOLVED] In need of a formula to rank highest to lowest
    By ellie2014 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-30-2014, 12:48 AM
  4. Replies: 12
    Last Post: 07-11-2013, 03:30 AM
  5. [SOLVED] Need a formula to rank highest to lowest values numerically
    By matt1020 in forum Excel General
    Replies: 3
    Last Post: 12-09-2012, 09:38 PM
  6. Excel 2007 : Rank cells by highest to lowest???
    By tvr1226 in forum Excel General
    Replies: 3
    Last Post: 11-29-2011, 02:59 AM
  7. [SOLVED] Rank where lowest value is highest rank
    By mile3024 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-09-2005, 07:00 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1