The file will find *one* solution, which may not be the first or the best
and the solution cannot be narrowed by applying criteria. It is a really
simple file that is one possible solution.

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
"Tom Ogilvy" wrote in message
...
Note that that will find one combination - not all combinations (unless
the
file has been changed recently).

--
Regards,
Tom Ogilvy

"Jim" wrote in message
...
Go to www.myweb.cableone.net/twodays
Download the "Find a numeric value" file.
--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
"Sherrie" wrote in message
...
I have a list of 479 rows. Column A is a product name, column B is
cost.
I
need to come up with every possible combination of pruducts that
equals
$100.

For instance:
Product A $100
Product B $50
Product C $38.72
Product D $20
Product E $30
Product F $50

Possible answers a
A
B+D+E
B+F
F+E+D

Each Product can be used only once so B+B wouldn't work.

PLEASE PLEASE PLEASE help!

Sherrie