Try this link:
http://tinyurl.com/7j3x2

HTH
Kostis Vezerides

JimBunch Wrote:
I have a known dollar amount and a range of lesser dollar amounts that I
need
to find possible sinarios that will add up to the known dollar amount.
Example:

Known Amt = $30
Range of Numbers:
a=$10
b=$10
c=$50
d=$20
e=$30
f=$15
g=$5
possiblilites: (a,d)(b,d)(a,f,g)(b,f,g)(e)

Any ideas?


--
vezerid
------------------------------------------------------------------------
vezerid's Profile: http://www.excelforum.com/member.php...o&userid=28481
View this thread: http://www.excelforum.com/showthread...hreadid=513997