solver

[Guest]

How can I use solver, or some other excel application to force the sum of a
column to equal a specified number, by allowing the numbers being summed to
either be changed to 0 or remain exactly the same?

It is essentially to determine which 50 or so of 100+ deposits are included
in an enormously large sum (1 large deposit total).

 

[Dnereb]

the only way to do that is use VBA and think of an algoritm to solv
your
sum.

If you want to calculate all possebility's don't be surprised to wai
for several years before it would have the best solution if there i
any.

it's an exploding situation

with three numbers there are 8 possebility's
with four , 16
with five , 32
with six , 64
7...128
8...256
9...512
10..1024

16.. 65532

32.. 42949766

with hundred.... 2 to the power of hundred

 

[Tushar Mehta]

How can I use solver, or some other excel application to force the sum of a
column to equal a specified number, by allowing the numbers being summed to
either be changed to 0 or remain exactly the same?

It is essentially to determine which 50 or so of 100+ deposits are included
in an enormously large sum (1 large deposit total).

Find a set of amounts that match a target value
http://www.tushar-mehta.com/excel/tips/template-set-match.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions