Iterative Calculation
Hello,
I have a Situation in sheets wherein I need to find if a particular stock has been fully used up
Eg:
Stock A -- Code1 -- 250units---0(balance)<----[250-100-100-50]
Stock used --- 100 units---Stock A(code 1)
Stock used --- 100 units---Stock A(code 1)
Stock A -- Code 2 -- 300 units---60(balance)<----[300-30(prev.balance)-80-150-60]
Stock used --- 80 units---Stock A(code 1)
Stock used --- 150 units---Stock A(code 1+code 2)
Stock used --- 60 units---Stock A(code 2)
Any help would be much appreciated
thanks
|