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.
Gary''s Student - 19 Sep 2006 00:47 GMT
See:
http://www.mrexcel.com/pc09.shtml

Signature
Gary's Student
> Is there a tool, or function that will analyze a range of numbers and
> identify those numbers that add up to another number?
[quoted text clipped - 10 lines]
>
> Thank you.