C
Chris Slight
Hello,
I am looking for a function that will do the following:
Basically I have a set of numbers, with part of the set making up one total
(when added) and the remainder of the set making up another total. I would
like to figure out the various combinations that when summed together will
give me output to these two totals. I was thinking that if I could generate
all the possible combinations, then I could use a lookup function to find
the total I am looking for. However, this may not give me the set of
numbers that yielded the total.
Basically what I have is this:
Set of #'s Total(s)
1 3 & 12
2
3
4
5
Return - 1,2 & 3,4,5 (I realize there are more combinations).
I have a set of 33 numbers, so it would take awhile to figure out by hand.
Any help or ideas would be appreciated.
Thanks
I am looking for a function that will do the following:
Basically I have a set of numbers, with part of the set making up one total
(when added) and the remainder of the set making up another total. I would
like to figure out the various combinations that when summed together will
give me output to these two totals. I was thinking that if I could generate
all the possible combinations, then I could use a lookup function to find
the total I am looking for. However, this may not give me the set of
numbers that yielded the total.
Basically what I have is this:
Set of #'s Total(s)
1 3 & 12
2
3
4
5
Return - 1,2 & 3,4,5 (I realize there are more combinations).
I have a set of 33 numbers, so it would take awhile to figure out by hand.
Any help or ideas would be appreciated.
Thanks