+ Reply to Thread
Results 1 to 7 of 7

Macro Scenario/Combination of letters

  1. #1
    Registered User
    Join Date
    04-19-2010
    Location
    Boston, MA
    MS-Off Ver
    Excel 2007
    Posts
    7

    Macro Scenario/Combination of letters

    Can someone please help me write a macro for a basketball league? We have four teams and 8 possible scenarios because of the following. TEAM A is matched against TEAM B while TEAM C is paired against TEAM D. Therefore, the possible scenarios are either A v. C and A or C wins or A v. D and A or D wins, or B v. C and B or C wins or B v. D and B or D wins.

    A v. C winner = A
    A v. C " = C
    A v. D " = A
    A v. D " = D
    B v. C " = B
    B v. C " = C
    B v. D " = B
    B v. D " = D

    Think of the possible combination for a Final Four National Champion. I have attached a spread sheet FYI. Any suggestions?

    Thank you,
    GC
    Attached Files Attached Files
    Last edited by GCo; 04-23-2010 at 09:30 AM. Reason: Bump no response

  2. #2
    Registered User
    Join Date
    04-19-2010
    Location
    Boston, MA
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Macro Scenario/Combination of letters

    Bump no response
    Last edited by GCo; 04-23-2010 at 09:30 AM. Reason: bump no response

  3. #3
    Registered User
    Join Date
    04-19-2010
    Location
    Boston, MA
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Macro Scenario/Combination of letters

    bump no response

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Macro Scenario/Combination of letters

    Hello GCo,

    I am not sure this what you want, but have a look at the link below. It may help.

    Tournament brackets
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  5. #5
    Registered User
    Join Date
    04-19-2010
    Location
    Boston, MA
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Macro Scenario/Combination of letters

    No, instead of a bracket, i am looking to write code for all the possible scenarios in a bracket. for example, in a Final Four there are 8 possible scenarios: A v. B and A wins; A v. B and B wins; C v. D and C wins; C v. D and D wins; A v. D and A wins; A v. D and D wins; C v. B and C wins; C v. B and B wins. Does that make sense?

  6. #6
    Registered User
    Join Date
    04-19-2010
    Location
    Boston, MA
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Macro Scenario/Combination of letters

    bump no response

  7. #7
    Registered User
    Join Date
    04-19-2010
    Location
    Boston, MA
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Macro Scenario/Combination of letters

    bump no response

+ 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