Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to distribute coins to achieve minimum difference?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
need help to achieve this calculation TUNGANA KURMA RAJU Excel Discussion (Misc queries) 1 February 23rd 07 01:03 PM
Using a formula across several columns to achieve a list of result G Bonham Excel Discussion (Misc queries) 0 January 11th 07 06:52 PM
How to lookup the minimum, 2nd minimum and 3rd minimum......... Mark McDonough Excel Worksheet Functions 8 July 15th 06 09:39 PM
Trying to achieve defined format with any Excel Striker475 New Users to Excel 1 November 11th 05 10:57 AM
Distribute Total Fable Excel Discussion (Misc queries) 0 July 25th 05 05:28 PM


All times are GMT +1. The time now is 05:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"