| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
For, Next, Loop vs. Select / Case Is
Garry
As always, ever reliable, and Dom thank you both for your assistance, the code works well... As for formulas, I have an IT Ogre who doesn't like nested formulas as he likes to see the effect, not the cause, so to speak.. I have been bangin' on a bit lately regarding Knapsack Problems, with that in mind, an added Rider: What is the maximum number of loops you can have with a maximum amount of loops... Loop 1 retains the first Group in Criteria = Group 1 Group 1 is then isolated, then Looped by another loop to find the next SubSet that matches the 2nd criteria. And this is where the Knapsack comes into play.. Those retained/grouped within the criteria then need to be grouped so that they sum to 22, but they can't exceed 24.5.. To find a solution to this would be my Everest, and to the top of it would be my graile... Thx heaps again guy's |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Case not recognized in Select Case | Excel Programming | |||
| Case without Select Case error problem | Excel Discussion (Misc queries) | |||
| End Select without Select Case, Block If without End If errors | Excel Programming | |||
| VBA Loop Case..If syntax | Excel Programming | |||
Threaded Mode
