I had one more question:

let's say i have a row of numbers:

1 2 3 4 5 6 7 8 9 etc

and I want to find and display all the combinations of 2, and 3

for 2:

1-2
1-3
1-4
etc

and for 3

1-2-3
1-2-4
1-2-5

etc

have any idea how to do that?

TIA!



"Max" wrote:

Another play which generates the desired results (but in a single column
separated by hyphens) that you might wish to delve into:
http://tinyurl.com/c2dpo

The play is extendable to handle up to a max 6 x 6 matrix (total: 36
different numbers) which generates 6^6 = 46,656 combos. The next step up, a
7 x 6 matrix, will yield 7^6 = 117649 combos, which would exceed Excel's max
65536 rows <g.

Modification steps are given in a later post in same thread:
http://tinyurl.com/9v6s2
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"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!