Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combinations
Hi, I am using the numbers 1 to 15. I need to calculate all the combinations
within these numbers to create 5 sets of 3 numbers eg. 1 2 3, 4 5 6, 7 8 9, 10 11 12, 13 14 15 eg. 1 2 4, 3 5 6, 7 8 9, 10 11 12, 13 14 15 so all of the 15 numbers have to be used up each time Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combinations
Have a look at either the =PERMUT() or =COMBIN() functions.
"Chris_t_2k5" wrote: Hi, I am using the numbers 1 to 15. I need to calculate all the combinations within these numbers to create 5 sets of 3 numbers eg. 1 2 3, 4 5 6, 7 8 9, 10 11 12, 13 14 15 eg. 1 2 4, 3 5 6, 7 8 9, 10 11 12, 13 14 15 so all of the 15 numbers have to be used up each time Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combinations
There are 1.3 x 10^12 permutations of 15 numbers. If you want to cover all possibilities I doubt that there is a spreadsheet big enough to hold the results. You might need to tackle your problem a different way. -- millsy ------------------------------------------------------------------------ millsy's Profile: http://www.excelforum.com/member.php...fo&userid=5122 View this thread: http://www.excelforum.com/showthread...hreadid=508945 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Combinations | Excel Discussion (Misc queries) | |||
Excel combinations from groups | Excel Discussion (Misc queries) | |||
Tennis set combinations | Excel Discussion (Misc queries) | |||
find all combinations of cells that add up to certain number | Excel Worksheet Functions | |||
triadic combinations of words | Excel Worksheet Functions |