As shown in figure:
Val is machining material specifications and qty is material number
The spec is raw material specification bal is raw material quantity

Goal is to use SQL to work out what kind of combination can be made minimum excess stock
Such as blue corresponding inline displayed above the material combination and the number of processing can be

At the bottom of the
The Spec Bal
4500 94 6
6000 92 1 7
On behalf of 4500 with 6 6000 with 7

CodePudding user response:

http://club.excelhome.net/forum.php? Mod=attachment& Aid=MjA0NzU4MXw4OTc1ODYyZHwxNTg5ODY2NzY1fDI4MDc0NDh8MTMzNTg3NA % 3 d % 3 d
Excel algorithm example is a great god, please reference

CodePudding user response:

Ready to knot stick, anyone reply to send points

CodePudding user response:

reply did not meh