+ Reply to Thread
Results 1 to 9 of 9

Combination/Permutation Formula

  1. #1
    Registered User
    Join Date
    02-12-2010
    Location
    Houston, TX
    MS-Off Ver
    Excel 2007
    Posts
    3

    Combination/Permutation Formula

    Howdy!

    Trying to come up with all possible combinations/permutations for testing a new product. Below are the twelve variable names and values (I've limited the possible values to two or three for ease of use). What formula can I use to generate ALL the possible combinations of the variables below?

    Thanks for any help you can provide. This is probably easy for someone smart. That someone is not me




    Category Possible Values

    Voltage: 12v 48v
    Res: D1 CIF
    BR: 2M 768 128
    FR: 30 10 1
    #Cam: 10 4 1
    Audio: 10 1 0
    GPS: DB9 LCD LED
    J1939: ON OFF
    PW: ON OFF
    SDT: HIGH LOW
    IGN: HIGH LOW
    REC: HIGH LOW
    Last edited by bryanlindsey; 02-15-2010 at 11:20 AM.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Please help - Hard for me, Easy for you

    Quote Originally Posted by bryanlindsey View Post
    Thanks for any help you can provide.
    ...to do what? I still don't see a question anywhere.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Please help - Hard for me, Easy for you

    Hello brianlindsey,

    welcome to the forum. However, your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Please help - Hard for me, Easy for you

    ... and then we'll fix you right up.

    You are aware there are over 30,000 combinations?
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    02-12-2010
    Location
    Houston, TX
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Please help - Combination/Permutation Formula Needed

    Sorry for the non-conformance. Hopefully my question is now more clear and in line with the forum rules.

    Thanks!

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Combination/Permutation Formula Needed

    See attached. Drag the formulas down another 30,000-odd lines to see all of the combinations.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    02-12-2010
    Location
    Houston, TX
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Combination/Permutation Formula Needed

    Wow. Thank you very much!

  8. #8
    Registered User
    Join Date
    03-18-2010
    Location
    Bay Area, California
    MS-Off Ver
    Excel 2008
    Posts
    1

    Re: Combination/Permutation Formula

    Wow. This is amazing. I am trying to do something similar. I have a product with 5 choices, and each choice has 8 options. This is something I do on a fairly regular basis - is there a basic formula for me to apply when trying to come up with all situations? I am trying to apply the example shown here and am still picking up pieces of my brain from the keyboard.

  9. #9
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Combination/Permutation Formula

    Welcome to the forum.

    Please take a few minutes to read the forum rules, and then start your own thread.

    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1