Locate numbers that sum to another

[Guest]

Is there a tool, or function that will analyze a range of numbers and
identify those numbers that add up to another number?

For example: I have a list of numbers.....

2
4
6
8

I want excel to analyze this list to tell me what combination sums to 6. In
this example, it would identify 2 and 4.....2+4=6.

Thank you.

 

[Guest]

See:


http://www.mrexcel.com/pc09.shtml