View Single Post
  #1   Report Post  
Mudflap
 
Posts: n/a
Default Can this be done...?

I am curious if there is a software package (for example, FoxPro and/or
Monte Carlo) or VB program/macro in Excel that can find a desired sum within
a column comprised of several rows of data. For example, if the following
were Column A in Excel:

1
3
4
6
8
2

and we wanted to find which combination of these entries (each used once)
totals 12, we know that 8+4 and 6+4+2 and 8+1+3 would be our combinations.
I'm trying to see if there is any other way than just "spotting" to see if
number combinations look like they'll match the totals.

Any ideas?