Combinations Generator Toolkit – Excel Template

PURPOSE

Combinations Generator Toolkit is a collection of Excel Templates that will allow you to instantly generate combinations from single list or multiple lists. These templates are designed to help you create selections from a list of items, with flexibility of number of items to select ( R ) and number of items to select from (N).

REQUIREMENTS

The templates require Excel 2016 or later for Windows. Also compatible with Office 365 or Microsoft 365 subscription, for Windows.

FEATURES

1. Instantly generate combinations – All required formulas are embedded.
2. Simple and Effective – Easy to use. Just type the items.
3. Customize the delimiter value between items
4. Copy the combinations and paste (as values) in any file
5. Two templates: supporting Single list and Multiple Lists

Limits

• Single List: N = 20, R = 7
• Multi-List: 10 lists, 20 items in each list

HIGHLIGHTS

Let us take a couple of examples to illustrate the functionality of the templates.

Single List

For example, let us take a list of 4 car manufacturers: Audi, BMW, Cadillac and Dodge. If we would like to generate combinations of them with 2 items, we would get 6 combinations, as shown below.

Audi – BMW, Audi – Cadillac, Audi – Dodge, BMW – Cadillac, BMW – Dodge, Cadillac – Dodge

The template would help generate this for your list of items.

If we want to generate combinations of 3 items at a time, we can change the R to be 3. Now, we would get 4 combinations as listed below.

Multiple Lists

If we need to pick an item from each list and we have 3 lists, the Multiple Lists version can support that. If we have car manufacturers in list 1 (Audi, BMW, Cadillac), Type of car in the second list (Sedan, SUV) and Number of doors in the third list (2 Door, 4 Door).

The template can now generate the following 12 combinations automatically.

For a good overview of Combinations and Permutations, please visit https://www.mathsisfun.com/combinatorics/combinations-permutations.html

If you need a customized version of combinations generator, please email us at support@indzara.com and we can develop a solution for a fee.

US\$35