Ok, here's the quandry that I'm in... I have a given set of numbers,
and a known total. I want excel to figure out for me which of those
numbers sum to my total. For example:

Code:
--------------------

12
36 1
54
92 1
33 1
57

--------------------

given this set of numbers, I'd like excel to tell me which cells will
add up to 161. if it could put a number, say a 1 in the cell to the
right of each cell being summed, that would be a good indicator
(36+92+33=161). and, by the way, the numbers are disparate enough that
there won't be multiple correct answers; the above set is simplified
for demonstration... Thanks in advance!!

-joe


--
jbourgui
------------------------------------------------------------------------
jbourgui's Profile: http://www.excelforum.com/member.php...o&userid=26205
View this thread: http://www.excelforum.com/showthread...hreadid=395114