Locate numbers that sum to another

S

simmerdown

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.
 
Top