Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
The Perfect Mix
Help Please!
Columns A2:E5000 Holds Quantities on hand. A1:E1 contain the ideal mix. Wante the number of ideal mixes in column F and the number of units left over in columns G:K What is the best calculation method to perfore the above. eg A1:E1 1,2,4,4,1 (ideal dozen) A2:E4 400,200,600,742,300 200,400,555,860,34 Ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing zeroes almost perfect | Excel Worksheet Functions | |||
how many perfect score | Excel Discussion (Misc queries) | |||
How to fit each cell into a perfect square? | Excel Discussion (Misc queries) | |||
Making the perfect sort. | Excel Discussion (Misc queries) | |||
looking for my perfect algorithm | Excel Discussion (Misc queries) |