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