Step 0:
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'.
Step 1:
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.
Step 2:
Choose Delimiter
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.
Step 3:
Refresh Calculations.
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.
Step 4:
View Output
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.
First Unprotect sheet using indzara as password. (How to unprotect?)
After unprotecting, click and drag down the edge of the table to extend to more rows (depending on how many you need) beyond 2000.
Processing Time
Please note that the more combinations (more the N or more the R) we have, Excel will need more time to process the calculations.
You will see a message in the bottom left corner, if Excel is still processing. Please wait until it finishes.
If the number of combinations (based on input) was entered incorrectly, you can click on the message and cancel the query.