|
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel,microsoft.public.excel.newusers
|
|
|
find sum in list of of numbers
Another method is by using solver like in this example
http://tinyurl.com/9suck
same constraints with larger numbers
--
Regards,
Peo Sjoblom
"Dave O" wrote in message
oups.com...
The answer is:
$725.90
$240.16
$207.70
I've written a program that applies a brute force approach to the task-
it checks every possible combination of the "pool" of numbers to arrive
at the target total. The brute force idea works for comparatively
small pools, but since the number of possible combinations doubles with
each additional pool member the processing time increases
commensurately. One poster to this newsgroup wanted to process a list
of 100 numbers, which amounts to
1,267,650,600,228,230,000,000,000,000,000 possible combinations and
would require the resources of a major government (or maybe just the
NSA) to process.
How many of these do you have? I don't mind doing a few for you.
|