Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() I would be grateful for help with listing all the possible game combinations within a set of tennis. I just need to list all the possible combinations of which player (1 or 2) wins each game. So for 6-0 to a player it is obviously 1,1,1,1,1. 6-1 can be 1,1,1,1,1,2,1 etc Is there a way excel can list all the possible combinations? Even if I just have a combination of all the ways 1 and 2 can win in a 12 game period. I guess it is just 2*2*2*2*2 etc but how do I list it in 1s and 2s? Hope this is clear! -- Raigmore ------------------------------------------------------------------------ Raigmore's Profile: http://www.excelforum.com/member.php...o&userid=30071 View this thread: http://www.excelforum.com/showthread...hreadid=497492 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Displaying all combinations of a range of numbers | Excel Worksheet Functions | |||
find all combinations of cells that add up to certain number | Excel Worksheet Functions | |||
find all combinations of cells that add up to certain number | Excel Discussion (Misc queries) | |||
Creating Combinations | Excel Worksheet Functions | |||
triadic combinations of words | Excel Worksheet Functions |