| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
how many combinations in a list equal a certain total
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum up combinations of numbers from list to get specific total | Excel Discussion (Misc queries) | |||
| Should grand total equal average of sub total | Excel Discussion (Misc queries) | |||
| Finding combinations to match a total | Excel Discussion (Misc queries) | |||
| Macro to add numbers to create combinations that equal certain amo | Excel Discussion (Misc queries) | |||
| Find combinations of numbers to equal a value | Excel Worksheet Functions | |||
![Sherrie[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
