Results 1 to 4 of 4

high scores and tiebreaker

Threaded View

  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

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