Home |
Search |
Today's Posts |
#1
|
|||
|
|||
solving for all possible combinations of a set of numbers
Hi
Let's say I have 6 sets 2 numbers: 1 2 3 17 18 19 7 8 9 10 11 12 What sort of function can I use to show all the possible combinations, where each number stays in its own column? For example, the first combination of 6 would be: 1 2 3 17 18 19 then 1 8 3 17 18 19 then 1 2 9 17 18 19 etc, where the 1 and the 7 stay in column 1, the 2 and the 8 stay in column 2, etc. TIA! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying all combinations of a range of numbers | Excel Worksheet Functions | |||
triadic combinations of words | Excel Worksheet Functions | |||
Combinations | Excel Worksheet Functions | |||
How to total itmes if they fall between a date range | Excel Worksheet Functions | |||
How to total items if they fall between a date range | Excel Discussion (Misc queries) |