+ Reply to Thread
Results 1 to 2 of 2

findingpossible combinations of numbers in a column that sum to a particular number

  1. #1
    Registered User
    Join Date
    01-30-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    14

    findingpossible combinations of numbers in a column that sum to a particular number

    Hi,

    I would like to be able to find all the possible combinations of numbers in a column that sum to a particular number.

    for example I would like to know what combination of the numbers below add up to 606

    253
    263
    851
    90
    521
    85


    in this case there are two possible answers 253 +263 +90, or 521+85

    If anyone has any suggestions that would be great.
    (also help with just finding the 1st possible answer would also be useful if finding both is too complicated, as there may only be one useful combination in my set of number anyway.

    Cheers

  2. #2
    Valued Forum Contributor smuzoen's Avatar
    Join Date
    10-28-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003/2007/2010
    Posts
    610

    Re: findingpossible combinations of numbers in a column that sum to a particular numb

    Here is a method of working with binomial co-efficients. You can modify the code to dictate various output limiting and dictate the inputs as well.
    Please Login or Register  to view this content.
    See attached workbook.
    Hope this helps.
    Anthony
    “Confidence never comes from having all the answers; it comes from being open to all the questions.”
    PS: Remember to mark your questions as Solved once you are satisfied and rate the answer(s) questions.”
    Attached Files Attached Files
    Last edited by smuzoen; 02-03-2012 at 06:27 AM. Reason: Fix code

+ 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