PRODUCT

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).

Combinations Generator Toolkit Excel Templates - TN
Combinations Generator Toolkit Excel Templates – TN

REQUIREMENTS

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

PRODUCT TOUR VIDEO

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
  • For scenarios not supported in the templates, please contact us (support@indzara.com) and we can develop a customized solution for a fee.

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.

Combinations - Example - Single List 4 items
Combinations – Example – Single List 4 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.

Combinations - Example - Single List 4 items 3
Combinations – Example – Single List 4 items 3

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.

Combinations - Multiple Lists - 3 Lists - Example Output
Combinations – Multiple Lists – 3 Lists – Example Output

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. 

BUY

US$35

CUSTOMER RATING

REASONS TO BUY

  • Download File Instantly
  • Free Email Support
  • One Time Payment. No recurring fees
  • Password provided to edit the file
  • 100% Money-back Guarantee
  • Trusted by more than 10k+ customers

100% SATISFACTION

If you are not satisfied with the product, please e-mail support@indzara.com and we will issue a full refund.

FILE DELIVERY PROCESS

You will be able to download the file immediately upon payment. You will also receive an e-mail immediately with the download link.

FREE UPGRADES

All future updates and upgrades are absolutely free.

LICENSE TERMS

PRODUCT SUPPORT

FAQ ARTICLES

OFFER

Offer Details

Special Offer - Buy One, Write Review, Get One Free

ADD A REVIEW

1 2 3 4 5

US$35