Creating combinations of different words

**egriffin** · 10-07-2010, 05:12 PM

So here is what I am trying to accomplish. I have 5 lists of different words and I want excel to read the lists and populate out all different combinations of the words. The best way to describe it is an example.

If I have 2 lists...

List 1 List 2
Baby Blonde
Child Brunette
Adult

I want excel to then populate a list in rows and columns that looks like this...

Baby Blonde
Baby Brunette
Child Blonde
Child Brunette
Adult Blonde
Adult Brunette

My list has many more options and will total over 8000 combinations so I dont want to do them all but a bunch of copy and pastes. If there is an excel function that will do this please let me know what it is.

Otherwise I see a VBA in my future.

Thanks

**shg** · 10-07-2010, 05:45 PM

See attached.

I closed your duplicate post. Please take a few minutes to read the forum rules before posting again.

Thanks.

**egriffin** · 10-08-2010, 09:32 AM

That is very close to what I am looking for except this always returns 20 combinations. I would like it to return every possible combination back. So if I have one list of 5 variables, another of 9, and another of 3...it will return 5x9x3=135 combinations.

Thanks

**shg** · 10-08-2010, 12:33 PM

Do you see the remarks in D3, D5, and D12?

To insert columns, select col C, copy, select col D, Insert > Copied cells

If you need to see additional rows, drag the formulas in row 32 down.