+ Reply to Thread
Results 1 to 10 of 10

tournament score board with tie breaker

  1. #1
    Registered User
    Join Date
    01-30-2015
    Location
    bandung
    MS-Off Ver
    2007
    Posts
    5

    tournament score board with tie breaker

    hello,
    i have tournament score board, it consist 3 stage and the point accumulate for total point and the highest go to top, i want to make point distribution like :

    1. 1st = 25 points
    2. 2nd = 20 points
    3. 3rd = 16 points
    4. 4th = 13 points
    5. 5th = 11 points
    6. 6th = 10 points
    7. 7th = 9 points
    8. 8th = 8 points
    9. 9th = 7 points
    10. 10th = 6 points

    and tie breaker for the rank are contestant with highest 3dmark 11 score

    sample :

    contestant A get total 50 points, and his 3dmark score 50000
    contestant B get total 50 points, and his 3dmark score 60000
    that mean contestant B will get the higher ranking

    and if there any function that can auto refresh and change rank everytime i input new score.

    any help will be much appreciated.


    warm regards
    Attached Files Attached Files

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: tournament score board with tie breaker

    change your rank formula to this... =RANK(L5,$L$5:$L$14)+COUNTIF($L$5:L5,L5)-1 and drag down.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    01-30-2015
    Location
    bandung
    MS-Off Ver
    2007
    Posts
    5

    Re: tournament score board with tie breaker

    Quote Originally Posted by Sambo kid View Post
    change your rank formula to this... =RANK(L5,$L$5:$L$14)+COUNTIF($L$5:L5,L5)-1 and drag down.
    thank u sambo kid

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: tournament score board with tie breaker

    glad that helped and thank you for adding to my reputation.
    if that solved your issue don't forget to mark the post as solved using the thread tools drop down at the top of this post.

  5. #5
    Registered User
    Join Date
    01-30-2015
    Location
    bandung
    MS-Off Ver
    2007
    Posts
    5

    Re: tournament score board with tie breaker

    Quote Originally Posted by Sambo kid View Post
    glad that helped and thank you for adding to my reputation.
    if that solved your issue don't forget to mark the post as solved using the thread tools drop down at the top of this post.
    it helped me a lot, actually i have one more question left, can i make point distribution like in the OP


    1st = 25 points
    2nd = 20 points
    3rd = 16 points
    4th = 13 points
    5th = 11 points
    6th = 10 points
    7th = 9 points
    8th = 8 points
    9th = 7 points
    10th = 6 points

    because from what i read if i using multi IF in excel it limited only to 8, so my 8th-10th position will have the same score.

  6. #6
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: tournament score board with tie breaker

    I think I see what you want, can you work with changing the formula in col G to this? =IF(f5=10000,25,IF(f5=9000,20,IF(f5=8000,16,IF(f5=7000,13,IF(f5=6000,11,IF(f5=5000,10,IF(f5=4000,9,IF(f5=3000,8,if(f5=2000,9,10)))))))))
    Now the important thing with this is that you have listed on your profile that you have MS office 2007 so that formula will work for you if you can save the file in .xlsx, if you only have 2003 or earlier (.xls) it will not work because it is too long.

  7. #7
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: tournament score board with tie breaker

    This may also work for you in col G... =LOOKUP(F5,{1000,2000,3000,4000,5000,6000,7000,8000,9000,10000},{6,7,8,9,10,11,13,16,20,25}) dragged down.

  8. #8
    Registered User
    Join Date
    01-30-2015
    Location
    bandung
    MS-Off Ver
    2007
    Posts
    5

    Re: tournament score board with tie breaker

    Quote Originally Posted by Sambo kid View Post
    I think I see what you want, can you work with changing the formula in col G to this? =IF(f5=10000,25,IF(f5=9000,20,IF(f5=8000,16,IF(f5=7000,13,IF(f5=6000,11,IF(f5=5000,10,IF(f5=4000,9,IF(f5=3000,8,if(f5=2000,9,10)))))))))
    Now the important thing with this is that you have listed on your profile that you have MS office 2007 so that formula will work for you if you can save the file in .xlsx, if you only have 2003 or earlier (.xls) it will not work because it is too long.
    problem solved now,, big thanks to u sambo kid

  9. #9
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: tournament score board with tie breaker

    =LOOKUP(K5,{1,2,3,4,5,6,7,8},{25,20,16,13,11,10,9,8})
    try like this
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  10. #10
    Registered User
    Join Date
    01-30-2015
    Location
    bandung
    MS-Off Ver
    2007
    Posts
    5

    Re: tournament score board with tie breaker

    Quote Originally Posted by nflsales View Post
    =LOOKUP(K5,{1,2,3,4,5,6,7,8},{25,20,16,13,11,10,9,8})
    try like this
    this formula completed what sambo kid gave me,, thank u so much for both of u, now my score board really work

+ 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. Replies: 1
    Last Post: 11-24-2013, 07:53 AM
  2. Moving a calclated score to a master score sheet and ranking the scores into placings
    By Jongleur69 in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 04-22-2013, 11:53 PM
  3. Trying to get a golf score board to work
    By andypking in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-25-2012, 06:55 AM
  4. Replies: 2
    Last Post: 03-20-2012, 06:30 PM
  5. Pulling test score based on date, not highest score.
    By PowerSchoolDude in forum Excel General
    Replies: 2
    Last Post: 12-01-2009, 06:42 PM

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