Combinations Generator Excel Template

Posted on
Combinations Generator Excel Template

A few months ago, I published a video (on YouTube) on how to create combinations of values in 2 lists. There have been requests to expand that to more than just 2 lists. So, here we go. I updated the formulas to accommodate 6 lists and made it into an easy-to-use free template.

Combinations Generator Excel Template
Combinations Generator Excel Template

FREE DOWNLOAD

Combinations Generator Excel Template

HOW TO USE THE TEMPLATE

It is one of the simplest templates published on indzara.com.

Just enter your values in each list (max 6) and see the combinations automatically calculated and displayed.

Combinations Generator Excel Template
Combinations Generator Excel Template

You can also change the separator (character that separates the values in the concatenated string of values)

When entering data, ensure the following are avoided

  • No blank values in the middle of any list
  • Enter lists sequentially (eg. please do not enter list 6 when list 5 is empty)

VIDEO DEMO

LIMITS

  • You can enter up to 6 lists
  • 500 combinations are supported by default. The formulas are hidden in the HELP sheet. You are welcome to edit and expand to more combinations if needed.

4 thoughts on “Combinations Generator Excel Template

  1. Great workbook. Thank you for the excellent knowledge share.

    1. Thanks for sharing your positive experience.
      Best wishes

  2. This is exactly what I was looking for. Thank you.

    1. Thanks for sharing your positive experience.
      Best wishes

Leave a Reply

Your email address will not be published. Required fields are marked *