+ Reply to Thread
Results 1 to 4 of 4

high scores and tiebreaker

  1. #1
    Registered User
    Join Date
    09-30-2009
    Location
    Louisiana
    MS-Off Ver
    Excel 2003, 2000,
    Posts
    2

    high scores and tiebreaker

    Finding high scores and breaking ties for multiple events

    I need some help with this spreadsheet. This is for a forestry contest. Students compete in 6 different categories (columns B through G). Teams can have up to four members and the top three member scores are taken to determine a team score. Teams are then ranked.
    Here is where I need help. I would like to be able to find the high individual score for each category in the contest. (sawlog, pulpwood, tree ID, etc) If there is a tie in the category it is broken using the category in the column to the right. Example – sawlog 1st tie breaker is pulpwood, the 2nd tiebreaker is thinning. The last column, Compass, uses sawlog as 1st tie breaker and pulpwood as 2nd tiebreaker.

    Example
    Will on the RHS team had a score of 112 in Tree ID and a score of 48 in thinning.
    Michael on the WHS team also had a 112 score in Tree ID and a score of 44 in Thinning.
    So Will is the high individual in that event –
    How can I create a formula that will bring the winners name down to row 66-71 and also bring the score down to row 66-71 to show who won each event?

    example spreadsheet attached

    Thanks in advance to anyone that can offer some help!
    Attached Files Attached Files
    Last edited by odha; 10-01-2009 at 01:18 PM. Reason: trying to get a better title

  2. #2
    Valued Forum Contributor
    Join Date
    07-29-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2003/Excel 2010
    Posts
    534

    Re: high scores and tiebreaker

    With minor modification to the layout (simplifies formula's)
    Attached Files Attached Files

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: high scores and tiebreaker

    Generally these calcs are a lot easier if you use helpers else you're looking at rather expensive arrays - the helper columns shown here can be hidden from view etc but they simplify the process significantly.

    Note: the numbers in rows 66:71 are formatted to show 0 decimals but WHER's approach is far more logical (ie just use MAX - depends in truth if you need to do any other analysis based on the MAX value).
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-30-2009
    Location
    Louisiana
    MS-Off Ver
    Excel 2003, 2000,
    Posts
    2

    Re: high scores and tiebreaker

    Awesome Job!!

    Thanks for your help - I have been trying to figure this out for a while now.

+ 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