+ Reply to Thread
Results 1 to 2 of 2

Breaking ties using vlookup, if, etc.

  1. #1
    Registered User
    Join Date
    11-02-2013
    Location
    OHIO
    MS-Off Ver
    Excel 2003
    Posts
    2

    Breaking ties using vlookup, if, etc.

    I'm trying to build a bracket for bowling where 8 guys bowl head to head but i'm having a hard time accounting for two guys tie. If they tie in gm1, then the higher of the two in gm2 advances to the next round. That's the first problem.

    The 2nd problem is if two guys in gm2 tie, then I need to break that tie before I compare his score to the other part of the bracket in game 2. Even though its highly unlikely to happen, I still want to account for it.

    I have all their scores on another tab "Scores" and trying to use vlookup to use the following game decides the tie breaker for game 1. So if Lancia and Joe tie in gm1 at 11 and then Joe beats Lancia 17-15 in game 2, i need it to show Joe won the first game via tie breaker score of game 2.

    But what if Joe and Lancia tie again in game 2? The winner of Lancia/Joe bowls against Long in the 2nd game. And to take it a step further, what if Lancia/Joe/Long all tie in game 2? And to make it even worse, what if Rader and Long tie in game 1, Lancia and Joe tie in game 1 - and then they all tie 4 tie in game 2? I need to take the winner of Rader/Long vs. the winner of Lancia/Joe based on tie breaker of game 3.

    I know I've rambled but if anyone can help, that'd be awesome.
    Thanks all.
    Rob
    Last edited by RJR34; 11-02-2013 at 10:19 PM. Reason: adding attachment

  2. #2
    Registered User
    Join Date
    11-02-2013
    Location
    OHIO
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Breaking ties using vlookup, if, etc.

    what the heck? how do i attach my sheet?
    Attached Files Attached Files

+ 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 - Breaking Ties
    By sachinattri in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-28-2013, 04:32 AM
  2. [SOLVED] Song competition - ranking order and breaking ties
    By tonyb212 in forum Excel General
    Replies: 12
    Last Post: 04-15-2012, 09:16 AM
  3. Breaking ties with rank alphabetically
    By ktms in forum Excel General
    Replies: 7
    Last Post: 11-03-2011, 07:06 PM
  4. Ranking - Ties
    By Marvo in forum Excel General
    Replies: 11
    Last Post: 07-06-2009, 10:12 AM
  5. Breaking Ties in Ranking
    By Zainuddin Zakaria in forum Excel General
    Replies: 4
    Last Post: 03-05-2006, 04:00 AM

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