Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I get 2 bags and 5 coins with different values, such as
The values for each coin are 14, 21, 23, 30, and 37. I need to put coins into 2 bags to achieve minimum difference for both. For example, I can put 14, 21, 23 into bag 1 and 30, 37 into bag 2. The difference for both bags is 14+21+23 = 58 30+37 = 67 The difference is 67 - 58 = 9. How do I know whether I achieve the minimum difference between 2 bags? Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
need help to achieve this calculation | Excel Discussion (Misc queries) | |||
Using a formula across several columns to achieve a list of result | Excel Discussion (Misc queries) | |||
How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions | |||
Trying to achieve defined format with any Excel | New Users to Excel | |||
Distribute Total | Excel Discussion (Misc queries) |