Hi Nigel

Thanks for taking the time to reply.

To my mind you are talking about permutations rather than combinations.
Please correct me if I'm wrong.

This is what I'm trying to say in the follow up post.
If I use c, d, e, f, g then I'm left with a, b, h, i, j. The order they are
in is irrelevant.

Similarly if I specify 4 letters to be used it returns a list of all the
possible combinations of 4 letters from the list of 10 and also the 6 letters
that were not used in the 4 letter combination.

Hope this is a bit clearer.

Regards

Les.



"Nigel" wrote:

Hi Les
Are you asking to list all combinations of the two sets; the chosen group
and the rest in the worksheet in two columns?

If you chose all 10 you would overflow the sheet with over 3.6 million rows.
So I am assuming the choice would be 9 or less?

Not sure I understand your supplementary post, as if you chose A to E; this
would result in 120 combinations; the remainder F-J would also have 120

Finally how would you like to choose the set?
--

Regards,
Nigel




"Les" wrote in message
...


"Les" wrote:

Hello

I have the letters A - J (10 in total).
There is 1 letter in each cell from A1 to A10 or A1 to J1 if you prefer.

I'm trying to produce a list of combinations, not permutations, for
however
many characters I use and what the remaining combination of characters
are.

e.g. I want to use 5 characters a - e, what are all possible combinations
of
those 5 charcaters and what are possible combinations of the remaining
characters.

another e.g. I want to use 3 characters c - e, what are the combinations
of
those 3 and then the remaining 7

Thanks in advance

Sorry, a little confusing, if you were to use 5 letters a, b, c, d, e then
there would only be one remaining combination possible fg,h, i, j.

Thanks