Excel permutations word generator

[Tonx101]

I have the following list in an excel sheet

Column A

Red

Green

Blue

White

Black

Question : I’m looking for a script of some kind that will create a permutation of all these words that’s possible without repeating. However, with minor thing the items of red and green must be included in each permutation, so for example two possibilities could. :

• red + green + blue
• red + green + black

We should never get an example like this: blue + white + black. This is because red + green isn’t included.

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:
Excel permutations word generator
and

Excel permutations word generator

I have the following list in an excel sheet Column A Red Green Blue White Black Question : Im looking for a script of some kind that will create a permutation of all these words thats possible without repeating. However, with minor thing the items of red and green must be included in...

www.excelforum.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.