View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
Jim[_28_] Jim[_28_] is offline
external usenet poster
 
Posts: 6
Default how many combinations in a list equal a certain total

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