-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Rijnsent
Well-known Member
- Joined
- Oct 17, 2005
- Messages
- 1,460
- Office Version
- 365
- Platform
- Windows
Try this: in column A, put the numbers 0 to 255 (a zero in A1, A2: =A1+1 , drag down).
Next, B1: =DEC2BIN(A1,8) -> drag down. That's basically the binary representation of the numbers.
Now you basically have your answer: all possible combinations, where every digit of the number represents one game and 0 means "team A wins" and 1 means "team B wins". You could grab the individual digits with a MID function.
Cheers,
Koen
Next, B1: =DEC2BIN(A1,8) -> drag down. That's basically the binary representation of the numbers.
Now you basically have your answer: all possible combinations, where every digit of the number represents one game and 0 means "team A wins" and 1 means "team B wins". You could grab the individual digits with a MID function.
Cheers,
Koen
Upvote
0
Similar threads
