procedure :Recursion

[ElmerS]

Hi,

Is there a "ready made" Recursion procedure that can be adopted in order to present the numbers that sum up to a given number ?

for example:
In cells A1:A10 there are 10 numbers (could be any numbers).
1
2
3
4
5
6
7
8
9
10

The sum request is: 8
The procedure should present, in column "C" the unique numbers that sum up to Exactly 8

In this example, the results to be presented, in B1:B5, are:
1,7
2,6
3,5
1,2,5
1,3,4

Thanks, Elmer

[royUK]

I think you will need to look at Excel's Solver feature

[ElmerS]

Thank you.

I could not figure out how to use the "Solver" to solve my request.

Would you be so kind to present an Example and/or some Link(s) to where from such a calculation can be adopted.

Elm

[royUK]

Try Google, e.g
http://www.vertex42.com/ExcelArticle...-examples.html

[ElmerS]

Believe me that I know how to Google...

However I did not find anything that comes even close to what I was asking.

Elm

[shg]

Please Login or Register  to view this content.

For your example,

Please Login or Register  to view this content.

[ElmerS]

Super Professional.

But... if I'm not mistaken the code results are presented as the Cells Number and not their content.

Upon trying to match a sum of 55 - for the A1:A5 (here below), the code presents 1,2 instead of 22, 33.

22
33
45
35
66

What can be changed in order to present the values that match the requested sum

Thanks, Elm

[Armando Montes]

Check this out:
http://www.geocities.com/excelmx/SumTarget.xls

[ElmerS]

Thank you Armando,

However, if you'll try:
1
2
3
4
5
6
7
8
9
10

for a sum of 8 - you'll find out it ends up with only one single value: 8 while I want to see all combinations that match the sum of 8.

If you'll look closer you'll see that there are at least 5 different pairs that match the requested sum.

Elm