+ Reply to Thread
Results 1 to 5 of 5

Ranking a range of data in descending order

  1. #1
    Registered User
    Join Date
    02-27-2013
    Location
    Washington, US
    MS-Off Ver
    Excel 2007
    Posts
    4

    Ranking a range of data in descending order

    I am trying to rank a range of data. I want it to look like the following. any help would be appreciated!!!

    Rank
    -$0.82 1
    -$0.88 2
    -$0.90 3
    -$0.92 4
    -$0.92 4
    -$0.94 6
    -$0.95 7
    -$0.95 7
    -$0.95 7
    -$0.97 10
    -$0.98 11
    -$1.02 12
    -$1.02 12
    -$1.02 12
    -$1.04 15
    -$1.05 16
    -$1.06 17
    -$1.07 18
    -$1.07 18
    -$1.07 18
    -$1.07 18
    -$1.07 18
    -$1.09 23
    -$1.09 23
    -$1.09 23
    -$1.10 26
    -$1.11 27
    -$1.11 27
    -$1.11 27
    Last edited by wizardshoes; 02-27-2013 at 04:25 PM.

  2. #2
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Ranking a range of data in descending order

    I searched google for "Ranking a range of data in descending order", and got the following link. It should be exactly what you need: http://www.k2e.com/tech-update/tips/...ithout-sorting
    Please click the * icon below if I have helped.

  3. #3
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Ranking a range of data in descending order

    you could use the rank function, with the [Optional 3rd parameter set to 0, for descending]
    =RANK(A1,$A$1:$A$29,0)

    Hope this helps

    Edit- actually, works on the sample data without the third parameter too:

    =RANK(A1,$A$1:$A$29)
    Last edited by dredwolf; 02-27-2013 at 05:23 PM.
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  4. #4
    Registered User
    Join Date
    02-27-2013
    Location
    Washington, US
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Ranking a range of data in descending order

    The rank function is close to working but it does not account for duplicate numbers.

  5. #5
    Registered User
    Join Date
    02-27-2013
    Location
    Washington, US
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Ranking a range of data in descending order

    Actually i figured out the issue!!! i needed to have the number rounded from a previous formula. Once i rounded it it worked perfectly. Awesome!!! Thank you so much!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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