Search for numbers that equal one total

[cmorten82]

I am looking for a formula that would reference a column and give me all the numbers that would equal one number. so if I was looking for an amount that was broken into smaller amounts it would identify only the numbers that would total that amount. I might have just repeated myself, my brain is going a mile a minute.

"Always assume Someone else thought of it first"

~Unknown

[José Augusto]

Hi
This seems to me to be the same as that placed in the post http://www.excelforum.com/search.php?searchid=4467096
and for which I presented an Excel array formula for a sub-list of 9 elements

Best regards

Search:
Keyword(s): 4467096

[wy7200]

I was looking for the same thing to!

couldn't find that link Jose posted. http://www.excelforum.com/search.php?searchid=4467096 searching for the numbers brings up this thread and another thread that list the link again. tried following the two links in that thread but neither code or downloaded excel sheet work.

I'm looking to divide a number into possible combinations of 39,44,and 15.

[José Augusto]

See the link
http://www.excelforum.com/search.php?searchid=4864789
Regards

[wy7200]

Says, "Sorry - no matches."

[José Augusto]

Hi

See the file Sample_6.xlsx
Regards