Results 1 to 7 of 7

Tie Breaker

Threaded View

  1. #1
    Registered User
    Join Date
    12-22-2009
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2007
    Posts
    26

    Tie Breaker

    I have read a lot of posts about tie breakers and using "Composite scores" and "helper columns" to sort out the winner. They make sense, but the problem I have is when you are working with 3 or more tie breaker elements .

    Example - Two players are tied with their point total. After the first tie breaker player 2 wins. It should stop right there, but with the composite scoring, it tallies the 2, 3 and 4 tie breakers. So in theory, a player that does better in tie breaker 2, 3, or 4 could place higher even though they lost the main tie breaker.

    I have tried placing weight values of significance with each tie breaker, but it still comes up with the same possibility.

    Is there a way to stop the formula after the first tie breaker if it generates a winner, then if still tied go to second tie breaker, etc?

    Thank you for your help.
    Last edited by allnet000; 02-11-2010 at 04:10 PM.

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