Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I 'nest' multiple quantities from standard stock lengths
I have random quantity lengths which I need to cut from standard stock
lengths. Is there a formula to calculate this 'Nesting' Facility. a b c d eg. random quantity lengths = , , , Available stock Lengths = 9.0, 10.5, 12.0, 13.5, 15.0 Nesting Answer = a+d b+c 1@ 10.5 + 1@ 12.0 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Last piece of text in a string (multiple lengths) | Excel Discussion (Misc queries) | |||
Economical grouping of lengths out of much longer lengths | Excel Worksheet Functions | |||
Web Query With Multiple Stock Symbols & Stock Scouter | Excel Worksheet Functions | |||
how do i get a set of pieces from a given # with standard lengths | Excel Worksheet Functions | |||
Finding duplicate entries with matching lengths, total the quantities, delete the extras | Excel Programming |