+ Reply to Thread
Results 1 to 3 of 3

Possible Combinations Of A Given Set Of Numbers??

  1. #1
    Registered User
    Join Date
    02-28-2007
    Posts
    1

    Unhappy Possible Combinations Of A Given Set Of Numbers??

    HELP!!

    I need to know the formula (if there is one) for Excel to figure all the possible combinations of a given set of numbers that will add up to a specified sum.

    In other words, if I give the following numbers 1, 2, 2, 3, 3, 4, 5, 5, 6, 7, 7 - I want Excel to figure all the possible combinations that will add up to 23, and also SHOW ME those combinations, and not just HOW MANY combinations there are.

    i.e. one possible combination is 2, 2, 3, 4, 5, 7

    Can this be done? What is the formula? I'm having a hard time figuring it out!!

    Desperately,
    Jenny

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by Jennylyn1
    HELP!!

    I need to know the formula (if there is one) for Excel to figure all the possible combinations of a given set of numbers that will add up to a specified sum.

    In other words, if I give the following numbers 1, 2, 2, 3, 3, 4, 5, 5, 6, 7, 7 - I want Excel to figure all the possible combinations that will add up to 23, and also SHOW ME those combinations, and not just HOW MANY combinations there are.

    i.e. one possible combination is 2, 2, 3, 4, 5, 7

    Can this be done? What is the formula? I'm having a hard time figuring it out!!

    Desperately,
    Jenny
    Hi,

    a look at http://www.dailydoseofexcel.com/arch...sum-to-target/ will show one method of 'Which Numbers', but applying variations to this could be a problem.

    hth
    ---
    Si fractum non sit, noli id reficere.

  3. #3
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Here's another link that might help, you will have to download the Excel Template - I've used it, it does work

    http://www.tushar-mehta.com/excel/te...ues/index.html
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

+ 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