Combining text from multiple lists to find all permutations.

[Mountaintopal]

I have seven different groups / lists and I'm trying to find the best way to pull one option from each list in order and get every permutation.

Example:

Sever Operating System:
None Installed
Windows 2008

Sever Memory:
None Installed
2GB
4GB

Hard Drive Bay 1:
No Hard Drive
72GB
300GB
500GB

There are 7 groups and each group has a different amount of items. Not sure the best way to quickly generate all the permutations in excel.

[taps]

Hi Mountaintopal,

Welcome to Excel Forum.
Please upload a supporting excel file with the solution.

regards
taps

[Mountaintopal]

Not sure I follow. I'm asking for help finding a solution using excel. I can't really upload the solution without knowing it.

[:) Sixthsense :)]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[shg]

There's a workbook with both formula-based and VBA-based methods to do this at https://www.box.com/s/47b28f19d794b25511be

[Mountaintopal]

Wow, thanks this is great! One question, how do I get the VBA tab to not use the blank cells. I added more columns since I have seven groups and each group has a different amount of options. It is adding the blank cells in the shorter groups as actual options.

[shg]

It doesn't use blank cells, as the example shows.

Make sure that the cells you don't want used are truly blank.