REach o fixed number from different combinations
Hi,
You can use the Solver tool, however, there are often multiple solutions to
this kind of problem and Solver only returns one result.
Consider
1
2
3
4
5
6
If the total I have is 7 what combination of numbers will give that result?
1+6
or
2+5
or
3+4
or
1+2+4
.....
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"c_riss" wrote in message
...
I need to reach a number using different combinations from a number
of cells. For example cells filled in with numbers A:A100 and I need to
know
how excel can identify the cells who can be sum to reach a fixed number.
|