• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Macro to get the max limit pack

deepak.djmechdj

New Member
Hi Guys.



I have a set of values a=12.2, b=13.4, c=14.6............( 100+Items, average value for these items is 15.2 ),



I need to create a pack of 20 items which should have max value but with in limit 350.



Result:

Max value: 248

20 Items = q,w,e,r,t,y,u,i,o,p,a,s,d,f,g



Please Help with a VBA logic / Code to compile these kind of input.



Thanks and regards

DJ
 
deepak.djmechdj
You should upload a sample Excel file
as written in Forum Rules, which You have just read
with sample data as well as expected results.
Your 20 items ... seems to have 15 letters
 
thanks for writing us back
Hi I have Created a sample file. Please help

Added one more criteria related to tags A And B in sample sheet
 

Attachments

  • VBA sample.xlsx
    20 KB · Views: 3
Task is to Make max number of packs as possible, and satisfying Conditions

Pack should contain 20 Items

1. No: of A Tag items = 19 unique items
2. No: of B Tag items = 1 unique items

Value Max Sum limit should be below 350
 
Back
Top