+ Reply to Thread
Results 1 to 1 of 1

How to generate all possible outcomes from different number of matches

  1. #1
    Registered User
    Join Date
    09-09-2011
    Location
    Finland
    MS-Off Ver
    Excel 2010
    Posts
    91

    How to generate all possible outcomes from different number of matches

    One match has three possible outcomes 1X2. I want to generate all possible combinations from different number of matches. For example if there is five matches there is 3^5 possible outcomes and i want to list them all to Excel. I also want that next time i could just change the number of matches and all the possible outcomes are again listed.

    I attached a simble file the make it more clear what i am looking for.

    Thank you for all the help!
    Attached Files Attached Files

+ 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: 2
    Last Post: 05-01-2014, 09:13 PM
  2. [SOLVED] Generate all possible outcomes
    By AmpleFlame in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-06-2013, 07:46 PM
  3. Require a solution to generate 3 outcomes to an IF statement
    By Phil Bruton in forum Excel General
    Replies: 5
    Last Post: 07-17-2010, 01:48 PM
  4. Simpler way to record the outcomes of matches
    By Newman100 in forum Excel General
    Replies: 10
    Last Post: 02-09-2009, 09:11 PM
  5. generate numbers given probability of outcomes
    By jerdjets in forum Excel General
    Replies: 5
    Last Post: 11-15-2007, 07:25 AM

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