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?