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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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


.

Quantcast