In F2 put in the formula:
=ROUNDDOWN(MIN(A3:E3/$A$1:$E$1),0)
enter with Ctrl+shift+enter rather than just enter since this is an array
formula

In G2 put in this formula

=A2-($F2*A$1)
and drag fill it to the left to cell K2

then select F2:K2 and drag fill down the column

--
Regards,
Tom Ogilvy

"Ronald Cayne" wrote in message
...
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