Array Combinations with a Twist
Your first answer from Brian was excellent.
However, as you will see, there are 24 possible
combinations from 4 members.
Using the Excel function PERMUT, you will find out
that if you have 1 row with 10 words, there are a
possible 3,628,800 combinations
which means taht it would need 56 worksheets just to
display
the combinations possible for this 1 line.
Hope this isn't too gloomy, but I couldn't believe it when
I saw the number of combinations ..........
-----Original Message-----
I'm trying to rack my brain over this little problem...
I have an array that contains words from a string. As an
example, if a
string has the following (without the quotes): "The quick
brown fox"
the array would contain only the elements (without the
quotes) "The",
"quick", "brown", "fox".
What I would like to do is to output all possible
combinations of
those 4 array elements as ONE string (with the spaces
returned)
without repeating the same word twice in that string. To
continue on
with our example... some of the results would be: "The
fox brown
quick", or, "brown The fox quick" etc...
I know of the Join(x, " ") function that can help me
stick the array
elements back together as one string with spaces, but how
do I do the
combination process?
One last important aspect: The number of words in a
string (the
quantity of elements in the array) can be any length, but
generally
there is a minimum of at least 2 words, and a maximum of
10.
Any help greatly appreciated.
Ryan
.
|