+ 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

    Please don't be sorry it's me that's giving you all this work and I have been playing around with different scores and you seem to have pulled off the impossible, brilliant, didn't think it was possible!

    It's great that the final rankings now don't appear until the last game which is perfect but the program used to rank teams after every game on Page 2 which is the important part as that page is printed and handed out for informationbut but that doesn't happen anymore so is it possible to "rank" the teams on Page 2 on W & L etc as we go along after evry game but leave the final rank on cols QRS 39:47 blank until the last game as at the moment

    But please if you are not sure what I mean please ask me as I don't want to waste anymore of your time also;

    why does a blue background appear sometime?
    What would happen if a tied team is also tied with the same LSD figure? and
    Under my old system I could put in an X against both teams to show that (very occasionally) a game wasn't played is there any way round that?

    Many thanks again 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

    Hi Alan.

    I was not sure whether you want Rank or number 1 to 9 each week game.
    Only Final Game will come up.
    That sort.

    I have remove blue background and put X in if 3 or more teams end up a tied if
    1 team beat each other.
    That sort.

    Yes but never say impossible. There alway there. Just need find it the right formula and set up plan. All sports do different tied. Never the same. Your workbook was a real test for me. I enjoy doing it. My pool league and your workbook are different in tied.

    Let me know any problem

    Hope you enjoy it.

    Thank you for a star.

    Cheers
    Attached Files Attached Files
    Last edited by micope21; 06-03-2012 at 05:59 PM.
    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