Anyone know of program or Excel VBA to examine set of numbers for Sum match?

E

EagleOne

2003 & 2007

The list of numbers below is just for an example.

I am attempting to find a set of numbers that add up to a given amount i.e.; In this case, I know
the answer because I created the amount.

I realize that this could be a real processor hog- but is it reasonably possible in the PC world?

2,767.16
62.75
308.00
60.66
1,745.70
791.20
(2,767.16)
(180.00)
(90.00)
(180.00)
(104.86)
(104.86)
(65.38)
(43.65)
(112.09)
(13.48)
(200.01)
(19.91)
(12.68)
(6.12)
(99.52)
(23.40)
(1.24)
(32.12)
(12.26)
(4.35)
(0.12)
(0.06)
(0.06)
(1,745.70)
(791.20)
(44.16)
(730.29)

Total (1,649.21)

What combination of the above will add up to i.e.: 1,539.45?

Answer:
-200.01
-.0.12
-6.12
1745.20

Any help or ideas is very helpful.

TIA EagleOne
 
M

Moe Green

Couple of approaches here...
http://www.tushar-mehta.com/excel/templates/match_values/index.html#Solver_Template
Moe



<[email protected]>
wrote in message
2003 & 2007
The list of numbers below is just for an example.
I am attempting to find a set of numbers that add up to a given amount i.e.; In this case, I know
the answer because I created the amount.
I realize that this could be a real processor hog- but is it reasonably possible in the PC world?

2,767.16
........
(730.29)

Total (1,649.21)
What combination of the above will add up to i.e.: 1,539.45?
Answer:
-200.01
-.0.12
-6.12
1745.20
Any help or ideas is very helpful.
TIA EagleOne
 
Top