Assume your numbers are in A1:F2
In A3 put in the formula

=IF(MOD(TRUNC((ROW()-3)/2^(COLUMN()-1)),2)=0,A$1,A$2)

and drag fill to F3. Now select A3:F3 and drag down to row 66 (A66:F66) -
64 combinations.

--
Regards,
Tom Ogilvy

"tradersm" wrote in message
...
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!