+ Reply to Thread
Results 1 to 5 of 5

Index/Rank Problem, based on criteria, if match then tiebreaker

  1. #1
    Registered User
    Join Date
    12-10-2008
    Location
    Kansas
    MS-Off Ver
    2007
    Posts
    91

    Angry Index/Rank Problem, based on criteria, if match then tiebreaker

    THe first part I have been able to complete (rank players from lowest to highest), but the problem Im running into is if there is a tie I need it to be broken by my tiebreaker table. I've attached a clear example.

    Thanks for the advice!


    Objective:

    Create a leaderboard that ranks players from lowest score to highest and if there is a tie score between two teams have the place decided by the tiebreaker table (lowest score on 1st Hardest Hole, if tie, lowest score on second hardest hole, etc..)

    For example, in my leaderboard Colin and Jack rank 3rd and 4th since they tied with Jay & Homer. What I want to occur is to recognize the tie and then compare the teams score on the hardest hole (column AB). If hardest hole is a tie, move on to the second hardest hole.


    Result: Jay and Homer should take 3rd place since they had the lower score on the 4th hardest hole (both teams had the same scores on the 1st, 2nd and 3rd hardest holes)
    Jay & Homer 64 - 3, 3, 4, 3
    Colin & Jack 64 - 3, 3, 4, 4

    another example is ...
    Ryan & Chuck 68 - 3, 3, 4, 4, 3 (5th place)
    Pat & Scott 68 - 3, 3, 4, 4, 4 (6th place)
    Attached Files Attached Files
    Last edited by brotherwo; 08-29-2012 at 10:15 AM.

  2. #2
    Registered User
    Join Date
    12-10-2008
    Location
    Kansas
    MS-Off Ver
    2007
    Posts
    91

    Re: Index/Rank Problem, based on criteria, if match then tiebreaker

    bump, any ideas?

  3. #3
    Registered User
    Join Date
    12-10-2008
    Location
    Kansas
    MS-Off Ver
    2007
    Posts
    91

    Re: Index/Rank Problem, based on criteria, if match then tiebreaker

    someone has to have some insight on this one, thanks in advance!

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Index/Rank Problem, based on criteria, if match then tiebreaker

    1) Put this in AJ5 and copy down:

    =(Y5&"."&AB5&AC5&AD5&AE5&AF5&AG5)+0


    2) Put this in AK5 and copy down to get the rank for each row:

    =RANK(AJ5, $AJ$5:$AJ$11,1)


    3) B17, copied down:

    =INDEX(A$5:A$11, MATCH(A17, $AK$5:$AK$11, 0))


    4) C17, copied down:

    =INDEX(B$5:B$11,MATCH(B17, $A$5:$A$11, 0))

  5. #5
    Registered User
    Join Date
    12-10-2008
    Location
    Kansas
    MS-Off Ver
    2007
    Posts
    91

    Re: Index/Rank Problem, based on criteria, if match then tiebreaker

    Awesome! Thanks so much
    Last edited by JBeaucaire; 08-29-2012 at 11:45 AM. Reason: Removed whole post quotation.

+ 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