+ Reply to Thread
Results 1 to 4 of 4

How to add six number sets, from 1 to 54-- target = 130 to 140

  1. #1
    Registered User
    Join Date
    04-18-2014
    Location
    Texas, USA
    MS-Off Ver
    Excel 2013
    Posts
    9

    How to add six number sets, from 1 to 54-- target = 130 to 140

    Guys I need help. I am trying to create a proprietary blend of chemicals for a product which is currently under development.
    I have 54 chemicals which I have labeled 1-54 based on volatility. I only need to combine six of the elements in varying amounts to get the reaction I desire.
    I know there are more than 25.8 million possible combinations but I don't need to know every one of them.
    I have surmised my best chances for success would be to have chemical combinations whose combined volatility indexes add up to somewhere between 130 and 140.

    This is where you guys come in. I am not familiar with the intricacies of MS Excel. I need it to do my thinking for me. Can you assist me with a formula I can use which would list all the numbers in separate columns between 1 and 54 in six number sets which, when combined, would add up to, for instance, 131 (or any other number I may need for it to), as in the example below?
    3 12 9 28 36 43 = 131
    6 16 44 23 25 17 = 131
    11 27 23 25 32 13 = 131
    13 22 21 9 50 16 = 131
    14 15 19 23 29 31 = 131
    27 22 31 16 9 26 = 131
    and so on

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

    Re: How to add six number sets, from 1 to 54-- target = 130 to 140

    Please Login or Register  to view this content.
    That's still north of 185,000 combinations, starting with these:

    A
    B
    C
    D
    E
    F
    1
    26
    25
    24
    23
    22
    20
    2
    27
    25
    24
    23
    21
    20
    3
    27
    25
    24
    23
    22
    19
    4
    27
    26
    24
    22
    21
    20
    5
    27
    26
    24
    23
    21
    19
    6
    27
    26
    24
    23
    22
    18
    7
    27
    26
    25
    22
    21
    19
    8
    27
    26
    25
    23
    20
    19
    9
    27
    26
    25
    23
    21
    18
    10
    27
    26
    25
    23
    22
    17
    11
    27
    26
    25
    24
    20
    18
    12
    27
    26
    25
    24
    21
    17
    13
    27
    26
    25
    24
    22
    16
    14
    27
    26
    25
    24
    23
    15
    15
    28
    25
    24
    22
    21
    20
    16
    28
    25
    24
    23
    21
    19
    Last edited by shg; 04-21-2014 at 06:03 PM.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    04-18-2014
    Location
    Texas, USA
    MS-Off Ver
    Excel 2013
    Posts
    9

    Re: How to add six number sets, from 1 to 54-- target = 130 to 140

    Sometimes the words "Thank you" just doesn't convey the amount of appreciation one might have for the assistance of another. I'm sure this is one of those times. This is exactly what we needed. At its commencement, we thought this project would be at least two years. This information you've provided us has both saved us time and also made us aware our two year goal may have been unrealistic.

    Many more thanks.
    You are amazing!!

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

    Re: How to add six number sets, from 1 to 54-- target = 130 to 140

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] divide a number closest to a target
    By koi in forum Excel General
    Replies: 3
    Last Post: 12-22-2012, 12:59 PM
  2. [SOLVED] Paste Data Range given Target Row number
    By SCLai in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-28-2012, 02:29 AM
  3. Percentage chance to hit target number
    By miinstrel in forum Excel General
    Replies: 3
    Last Post: 04-09-2011, 06:52 PM
  4. Target.Value - Must be a number
    By Desert Piranha in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2006, 08:26 PM
  5. Building to a target number
    By uship in forum Excel General
    Replies: 1
    Last Post: 08-07-2006, 08:45 PM

Tags for this Thread

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