+ Reply to Thread
Results 1 to 3 of 3

ranking values

  1. #1
    Registered User
    Join Date
    12-29-2003
    Posts
    33

    ranking values

    I have attached a worksheet so that it will make more sense.

    I just want to be able to plug in values in "Value B" and have a macro automatically sort in the correct order for the "RANK" columnn. The higher percentages get first placing and so on starting at 8 and going down to 1.

    This will be for a March Madness type bracket.

    The catch: Value A is a static value and will never change.

    Thoughts?

    Thanks for the help!
    Attached Files Attached Files

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    You could do ths quite easily with a formula, i.e. in C3 copied down

    =RANK(B3,B$3:B$10,1)

  3. #3
    Registered User
    Join Date
    12-29-2003
    Posts
    33
    Awesome. Thanks.

    2 More questions. How do I sort a column of negative numbers and have it sort by the highest negative number?

    Also, is there a way to have a row be highlited when it is the highest of the group? Like a conditional format?

    Thanks!

+ 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