Microsoft Excel Tutorial: Generating all combinations of N outcomes for K games.

In episode 2602, I had to generate all possible combinations of 4 games with 6 possible outcomes in each game. I used my very convoluted “binary count up, but not binary because it is base 6, but not base 6 because I need the digits 1 to 6 instead of 0 to 5” method. This involves a lot of typing and two different formulas.

Today, a much easier way from Kyle Freistedt. Kyle DOES use Base 6. He does use a SEQUENCE function but starts at 0 instead of 1. And then at the end, he uses +1111 to convert the 0 to 5 to 1 to 6.

In this video, I show Kyle’s method for the Jeopardy Masters problem and then I generalize the steps for any values of N and K.

To download this workbook: https://www.mrexcel.com/youtube/wLs8U2RMi7I/

Table of Contents
(0:00) Problem Statement
(0:24) Bill’s Convoluted Method
(0:43) Kyle’s Formula for Combinations using BASE
(1:00) Start the SEQUENCE at 0
(1:12) BASE function in Excel
(1:32) Clever: Add 1111
(2:02) One formula
(2:13) General steps for any N and K
(3:30) Break with MID and SEQUENCE?
(4:00) Break with TEXT and TEXTSPLIT?
(4:55) Thanks to Kyle