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?
Bookmarks