- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- Re: how many combinations in a list equal a certain total

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

- Re: how many combinations in a list equal a certain total posted by Tom Ogilvy on Thu, 30 Oct 2003

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