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!
|