+ Reply to Thread
Results 1 to 5 of 5

Find All Combinations That Equal A Given Sum use VBA

  1. 08-07-2020, 07:27 AM #1
    tronghoabg
    tronghoabg is offline
    Registered User
    Join Date
    08-07-2020
    Location
    Viet nam
    MS-Off Ver
    2020
    Posts
    2

    Lightbulb Find All Combinations That Equal A Given Sum use VBA

    hello every body, I'm want use VBA to Find All Combinations That Equal A Given Sum
    Ảnh chụp Màn hình 2020-08-07 lúc 6.25.37 CH.png
    please help me.
    thanks everybody.
    Attached Files Attached Files
    Last edited by tronghoabg; 08-07-2020 at 07:30 AM.
    Reply With QuoteRegister To Reply
  2. 08-07-2020, 07:40 AM #2
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Find All Combinations That Equal A Given Sum use VBA

    You'll find a nice explanation here: https://www.extendoffice.com/documen...given-sum.html
    or at our forum (I used a title of your post to search!): https://www.excelforum.com/excel-for...given-sum.html
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
  3. 08-07-2020, 07:48 AM #3
    Haluk
    Haluk is offline
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,150

    Re: Find All Combinations That Equal A Given Sum use VBA

    See this link:

    https://www.excelforum.com/excel-for...ml#post4828279


    @Kaper: Seems I've offered the same link but, I saw your link after posting my message.
    Last edited by Haluk; 08-07-2020 at 07:52 AM.
    Reply With QuoteRegister To Reply
  4. 08-07-2020, 09:08 AM #4
    tronghoabg
    tronghoabg is offline
    Registered User
    Join Date
    08-07-2020
    Location
    Viet nam
    MS-Off Ver
    2020
    Posts
    2

    Re: Find All Combinations That Equal A Given Sum use VBA

    it not working in excel on mac os
    Reply With QuoteRegister To Reply
  5. 08-07-2020, 09:14 AM #5
    MrShorty
    MrShorty is offline
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Find All Combinations That Equal A Given Sum use VBA

    Tushar Mehta has a VBA solution for the subset sum problem: http://www.tushar-mehta.com/excel/te...e_combinations
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find All Combinations That Equal A Given Sum
    By vikas_newports in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 03-29-2020, 09:11 AM
  2. Find All Combinations That Equal A Given Sum - Follow up Re Original Thread 01-28-2018
    By fleeboing in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-30-2018, 04:46 AM
  3. How to calculate combinations from set of data to equal sum
    By Rheanna in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 06-16-2015, 01:18 PM
  4. Find Possible Sum Combinations That Equal Given Value
    By mdsyam in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-11-2012, 04:21 AM
  5. Combinations of numbers to equal one total
    By Sunnangel in forum Excel General
    Replies: 2
    Last Post: 04-09-2009, 12:28 PM
  6. Number combinations to equal total
    By unitedfasteners in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-24-2008, 12:00 AM
  7. Find combinations of numbers to equal a value
    By jubu in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2005, 09:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1