Permutation & Combinations of Names of different lengths

[zaveed]

Hi,

i want to know if there is a macro which will give me the permutations and combinations of 5 names of different length that i have .

Example: Below are the 5 names of different lengths . for example

Names
Mark
Michelle
Sandra
Steve
Aaron

Output should be as below.

Output
MMSSA
MMSSr
MMSSo
MMSSN
MMSTA
MMSTR
MMSTO
MMSTN
MMSEA
MMSER
MMSEO
MMSEN


It should check each letter of the 1 name and give the permutation and combination with each letter in all the other 4 names.


Thank You

[JBeaucaire]

...with no repeats, ever? THe same 5 letters would not occur together, that's permutations. For instance, when the macro got to the SECOND letter "L" in Michelle, it would basically add nothing since all those permutations would have been created on the first "L".

[zaveed]

...with no repeats, ever? THe same 5 letters would not occur together, that's permutations. For instance, when the macro got to the SECOND letter "L" in Michelle, it would basically add nothing since all those permutations would have been created on the first "L".

Hi,

Yes that correct, if its the same letter then it would have already been listed in the output.


Thanks

[JBeaucaire]

With no repeats, that means AMMSS in the list would mean that MMSSA could not exist later, that's the same 5 letters in another order, so it's the same permutation. With that understanding, these two macros will do it:

Please Login or Register  to view this content.

You can add this line near the bottom of the main macro to sort the resulting list:

Please Login or Register  to view this content.

[zaveed]

Thank YOU. it worked.

Thanks
Zaveed