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