Find the combination of numbers equals to target or sum value

[RAJ008]

Dear Team,

I need one favour from you i want to find out the combination of numbers that equals to target value.
by using excel formula i tried but cant find the solution.please help me out ITS BIT URGENT.

<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:3364;width:69pt" width="92"> <col style="mso-width-source:userset;mso-width-alt:3181;width:65pt" width="87"> </colgroup><tbody>
[TD="class: xl68, width: 64"] Rate
[/TD]
[TD="class: xl68, width: 92"] Combination
[/TD]
[TD="class: xl71, width: 87"] Target value
[/TD]

[TD="class: xl67"] 0
[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl72"] -332.32
[/TD]

[TD="class: xl67"] 12.27 [/TD]
[TD="class: xl67"][/TD]
[TD="class: xl69"][/TD]

[TD="class: xl67"] -300.05 [/TD]
[TD="class: xl67"][/TD]
[TD="class: xl69"][/TD]

[TD="class: xl67"] 0
[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl69"][/TD]

[TD="class: xl67"] -185.32
[/TD]
[TD="class: xl67"] X
[/TD]
[TD="class: xl69"][/TD]

[TD="class: xl67"] -13
[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl69"][/TD]

[TD="class: xl67"] -50
[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl69"][/TD]

[TD="class: xl67"] -572 [/TD]
[TD="class: xl67"][/TD]
[TD="class: xl69"][/TD]

[TD="class: xl67"] -147 [/TD]
[TD="class: xl67"] X
[/TD]
[TD="class: xl69"][/TD]

[TD="class: xl67"] 60 [/TD]
[TD="class: xl67"][/TD]
[TD="class: xl69"][/TD]

[TD="class: xl67"] 6 [/TD]
[TD="class: xl67"][/TD]
[TD="class: xl69"][/TD]

[TD="class: xl67"] 500 [/TD]
[TD="class: xl67"][/TD]
[TD="class: xl69"][/TD]

[TD="class: xl67"] 0
[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl69"][/TD]

[TD="class: xl67"] -25 [/TD]
[TD="class: xl67"][/TD]
[TD="class: xl69"][/TD]

[TD="class: xl67"] -714.1
[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl69"][/TD]

</tbody>

 

[BrianJN1]

You might explain what values are to make up the combination and how they relate. For instance, do we have something to do with loans? Also, do you want just one value in "Combinations" or should there be more?

Please explain your question more clearly.