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
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