+ Reply to Thread
Results 1 to 3 of 3

Looking for a formula for 6 games with all possible outcomes

  1. #1
    Registered User
    Join Date
    09-25-2017
    Location
    london, ontario
    MS-Off Ver
    xp
    Posts
    2

    Looking for a formula for 6 games with all possible outcomes

    Looking for all the possible outcome for 6 games with only a win or loss possible.For each game. 64 total outcomes

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Looking for a formula for 6 games with all possible outcomes

    in A1 =DEC2BIN(ROW()-1,6) and down up to row#64

  3. #3
    Registered User
    Join Date
    09-25-2017
    Location
    london, ontario
    MS-Off Ver
    xp
    Posts
    2
    Quote Originally Posted by tim201110 View Post
    in A1 =DEC2BIN(ROW()-1,6) and down up to row#64


    I suck at excel. How do I do this step by step.
    The layout would look like this
    Game 1 1 vs, 2
    Game 2 3 vs 4
    Game 3 5 vs 6
    Game 4 7 vs 8
    Game 5 9 vs 10
    Game 6 11 vs 12

    Only outcome for each game is a win or loss.
    But all six games need to be included on each ticket

+ 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. Games Behind Formula
    By Milomet in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-24-2020, 03:24 PM
  2. Generate all possible combinations - 8 games, 2 teams, 3 outcomes
    By Aravia in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 05-30-2018, 10:39 PM
  3. [SOLVED] Baseball Results: H/G when Games<30 & AB/G when Games<10
    By Eric Alan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-16-2017, 02:29 AM
  4. Replies: 4
    Last Post: 03-31-2016, 11:43 PM
  5. Games Back Formula
    By socal.s in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2015, 08:10 PM
  6. Formula to calculate win/lost for last n games
    By cap_investing in forum Excel General
    Replies: 13
    Last Post: 01-06-2015, 07:50 PM
  7. Shortest Formula Challenge!! (Games 6 & 7)
    By clabulis in forum The Water Cooler
    Replies: 29
    Last Post: 07-30-2014, 10:11 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