Combinations Generator: Multiple Lists - Step by Step User Guide
Modified on: Sun, 26 Jul, 2020 at 1:42 PM
The template uses tables and queries. In such cases, Excel requires enabling data connections.
Please note that there is no external connections to any server of any computer. This template is a stand-alone Excel file that you download to your computer and all the data will reside in only your computer.
Please click on 'Enable Content'.
Enter list of values (or items) in each List. Max allowed in each list is 20. And there can be up to 10 lists.
In the screenshot above, we have entered data in 6 lists.
In the screenshot, I have enter ' - ' (space, hyphen, space). You can enter any delimiter you would prefer. You can leave it empty if you don't want a delimiter.
Since the template uses calculations behind the scenes, they need to be refreshed after you enter input data above. Every time, you make changes to the input data, please refresh calculations.
You will also see a message indicating that the data needs to be refreshed.
To refresh calculations, please click on 'Refresh All' in the DATA ribbon.
The output list of combinations will appear in the table.
Step 5 (Optional):
Combinations greater than 2000
If your output combinations is greater than 2000, you will see this message. This is because, by default, the 2000 combinations are displayed.
To extend, if you click on the red link, it will take you to the end of 2000 combinations.