Combinations Generator Excel Template

Posted on

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

This Excel Combinations Generator 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
Combination Excel Generator 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.

RECOMMENDED TEMPLATE

  • Combinations Generator Toolkit tn

    Combinations Generator Toolkit – Excel Template

    US$35
    Add to cart

You may also be interested in...

Sales Report Excel Template
Activity Pattern Heat Maps
Product Rating Report

41 thoughts on “Combinations Generator Excel Template

  1. Great Job! How can I combine using text and numbers in the tables but with no – between or no separators. AppleUSAHR no spaces?
    Thanks

    1. Thank you for showing interest in our template.

      You can add text in one column table and numbers in one table to combine together and you can delete the values in separator to remove the space between text and number.

      Best wishes.

  2. First of all, really thank you for this work; it saved a lot of time. I have one query, what if I wanna generate combinations of 7 or more items at a time from lists of 6 or less than 6?

    1. Thank you for using our template and you are welcome.
      Requesting to check the video link below to learn how to extend the lists:
      https://www.youtube.com/watch?v=Fu8Xw6_iz4Y
      You can also send the number of list required to support@indzara.com to take it as a customization project for a fee.
      Best wishes.

  3. Thank You

    1. You are welcome.
      Best wishes.

  4. you are genius and i am a big fan and subscribed to your channel and will follow you guys in anything you do on social media
    can we have an excel sheet with up to 99 lists …

    1. Thank you for subscribing to our channel and thank you for sharing your valuable feedback.
      We take customization projects for additional fee, requesting to contact our support team at support@indzara.com to get an estimate for the same.
      Best wishes.

  5. how do i increase the number of combinations?

    1. Thanks for using our template.

      Please unhide the help tab and extend the combinations table to accommodate more combinations.

      Best wishes

  6. This has been a time saver. Thank you!

    1. Welcome!!!

  7. Is there anyway we can get access to the HELP sheet that is used in this generator?

    1. Hello

      Please right-click on the tab to unhide the hidden sheets.

      Thanks

  8. HI
    I NEED COMPLETE LIST OF 1 TO 49 NUMBER 6 COMPINATIONS- WITH OUT REPAET IN EXCELL FORMAT

    1. Thanks for your message.

      We are not accepting any customized projects due to a heavy workload.

      Best wishes

  9. I have fifteen (15) lists how do I update the template or get a template for 15lists with more than 500 combinations.

    Thanks; Best regards.

    1. Thanks for your message.

      This template is designed for six lists and 500 combinations. Due to the heavy workload, we are not accepting any customized projects.

      Best wishes

  10. Am really waw! Too nice for me not commend. BRAVO.
    Please I need further help, i want to have all the possible outcomes for three letters eg. ABC with 15 Lists.
    How do i go about that.
    Thanks in anticipations.
    i.e One of the outcome can be all sigle of the letters

    AAA AAA AAA AAA AAA
    BBB BBB BBB BBB BBB
    CCC CCC CCC CCC CCC

    BAA AAA AAA AAA AAA
    CAA AAA AAA AAA AAA

    1. Thanks for using our template.

      This template can handle upto six lists.

      Best wishes

Leave a Reply to INDZARA.COM Customer Support Cancel reply

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