REach o fixed number from different combinations

C

c_riss

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.
 
S

Shane Devenshire

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
.....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top