Re: solving for all possible combinations of a set of numbers

Thank you, Max, that is exactly what I was looking for. If I make a million
I'll be sure to send you and the others here a generous tip

"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 <at>yahoo<dot>com
> ----
> "tradersm" <tradersm@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:93D9C21A-C5DC-4BA8-B832-B30E3C523732@xxxxxxxxxxxxxxxx
> > 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!
> >
> >
> >
> >
>
>
>
.