Thread: Combination Sum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] sharadmittal80@gmail.com is offline
external usenet poster
 
Posts: 3
Default Combination Sum

Hi

I need help in solving for an issue in excel. A macro is required.

We have a list of 700 numbers and we need to find out how many
combinations match a particular number, if we add numbers from the
list of 700. Example:

List of numbers:
1234
63
8903
3446
8112
854
.... and so on

Target: 8966

Solution:
Option 1:
8112+854
Option 2:
63+8903

Is this possible in excel macro. I found one here, but this is not
useful for more than 4 numbers.

http://en.allexperts.com/q/Excel-105...s-x-number.htm

I would appreciate it if a solution to this is available on excel or
any other software.