Re: how many combinations in a list equal a certain total

Giganews Newsgroups
Subject: Re: how many combinations in a list equal a certain total
Posted by:  Jim (twodays@nospamcableone.net)
Date: Thu, 30 Oct 2003

Go towww.myweb.cableone.net/twodays
Download the "Find a numeric value" file.

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
"Sherrie" <sb66…@sbc.com> wrote in message
news:et9k5NwnDHA.20…@TK2MSFTNGP09.phx.gbl...
> 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 are:
> 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

Replies

In response to

how many combinations in a list equal a certain total posted by Sherrie on Thu, 30 Oct 2003