Is there any way to have excel look at a list of numbers and return
possible combination of cells that would equal a specific value? For
instance:

List Sum 60
45 Possibles A2+A3, A4+A5+A6
45
30
30
10

Where List and Sum are givens and Possibles would give various options
for arriving at the sum.

If this is not possible, is there a way to do this when there is only
one possible formula?


--
Chris Berry
------------------------------------------------------------------------
Chris Berry's Profile: http://www.excelforum.com/member.php...o&userid=36165
View this thread: http://www.excelforum.com/showthread...hreadid=560458