Make a unique list from all separated value across multiple cells

[Andrew-Mark]

Apologies if this has been covered but I couldn't find anything.
I also apologise that on this occasion I have not even been able to get started.


I have a number of values in three columns that are separated consistently from each other.
I need to somehow create a list of all the possible combinations taking a value from each cell.

Is there a way of doing this with formulas or do I need to use VBA? Can it even be done with VBA?


Sample attached.

[AlKey]

Try this
Enter formula in F2 and copy down

Please Login or Register  to view this content.

Please see attached file.

[Bo_Ry]

Another way, please try at
H2

Please Login or Register  to view this content.

I2

Please Login or Register  to view this content.

[Fluff13]

With VBA

Please Login or Register  to view this content.

[Andrew-Mark]

I would just like to say thank you both as this is starting me down the route I can see I need to go.
Fluff; how would I adjust this VBA if I had multiple rows but always the same number of columns?
I am now thinking that I will have a singe product entered in column A with up to 5 options in Column B each of which can be got in many colours listed in column C. There wil also be multiple rows for the different products.

[Fluff13]

How about

Please Login or Register  to view this content.

[Andrew-Mark]

Thanks for that but I am getting an overflow error.

Is that because I have too many combinations?

I have attached a workbook with the actual combinations input.

[Fluff13]

Is that because I have too many combinations?

Yup, This will put the output in colsG, H etc

Please Login or Register  to view this content.

[Andrew-Mark]

Is there any way to get them in a long list rather than in a separate column each time?
I do apologise for this, I do prefer to try and learn all this but this line..

Please Login or Register  to view this content.

...is new to me and not sure how to alter it to make it work.

[Fluff13]

How about

Please Login or Register  to view this content.

[Andrew-Mark]

Damnit, I was so close with my attempts.
I wish I did VBA all the time so I knew it better.
I will give that a try and then mark this as SOLVED.

Thank you, thank you

[Fluff13]

Glad to help & thanks for the feedback