+ Reply to Thread
Results 1 to 31 of 31

Help to automate ranking of tied teams in sports scoring program

Hybrid View

  1. #1
    Registered User
    Join Date
    04-06-2007
    Location
    Glasgow, Scotland
    MS-Off Ver
    2003 / 2007
    Posts
    83

    Re: Help to automate ranking of tied teams in sports scoring program

    Thanks again for the changes but no it can happen that 2 teams or more might not have won a game and decide that as they can't qualify for the semies they might not bother playing, it's unusual but can happen, so they could pull out of the competition at a late stage so what I have done in other programs is that if an "X" appears against both teams instead of a W or L then it's game not played but they still appear in the ranking list but with 1 or more games less if you get my meaning in other words the program recognises either a W,L or X but the X just means a game less but the team is still listed and ranked until the end.

    Hope that is clear. Alan

  2. #2
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: Help to automate ranking of tied teams in sports scoring program

    Ok

    Have a look on sample 3 file.

    What I done with is -Countif with X on M9 to M26.
    This will bring it down to 70 or less instead stay on 72.

    Column results Z and AA I put in if with ISNA.
    Reason When Grid all blank get N/A on it. This will change to blank instead N/A.

    Let me know if done it or not?

    Cheers
    Attached Files Attached Files
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".

+ 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