Excel permutations word generator

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.

That is extremely easy to create.

How do you want the output?

Please Login or Register  to view this content.

I was looking to have the outlook to be in a list that shows all the output at once with red and green also being the first two.
And to also show all possible combo.....so the string could be up to 5

Are the real items not "colour"? try to post actual sample. its might be not hard to extract a combination list, I think.

Try this

Please Login or Register  to view this content.

Originally Posted by Tonx

this so super helpful! thanks so much...one more question.....how could I apply a check to ensure that the list are unique so they repeat in different order?
mean red+ green + blue ---> is the same as blue + red + green .......so wouldn't want this

Lots of cases like:Attachment 756931

Is it acceptable?

Correct me if I misunderstanding you:
"Red+Green" always present at beginning
For each Black, Blue, White (1,2,3)
Red+Green+color1
Red+Green+color1+color2
Red+Green+color1+color3
Red+Green+color1+color2+color3

4 cases for color1. Similar to color 2 and 3

Total: 4*3=12 cases of combination.

PHP Code: 

Sub test()
Dim myArr() As String
Set myCol = New Collection
myArr = Split("+Blue,+White,+Black,+Blue,+White", ",")

For i = 1 To 3
    myCol.Add myArr(i - 1)
    myCol.Add myArr(i - 1) & myArr(i)
    myCol.Add myArr(i - 1) & myArr(i + 1)
    myCol.Add myArr(i - 1) & myArr(i) & myArr(i + 1)
Next
For i = 1 To myCol.Count
Cells(i, 1).Value = "Red+Green" & myCol(i)
Next

End Sub