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+ Code 2)
Stock used --- 150 units---Stock A(code 2)
Stock used --- 60 units---Stock A(code 2)

Any help would be much appreciated

thanks

Rakesh.K

On Tuesday, 14 May 2019 08:00:24 UTC+1, wrote:
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+ Code 2)
Stock used --- 150 units---Stock A(code 2)
Stock used --- 60 units---Stock A(code 2)

Any help would be much appreciated

thanks

Rakesh.K

Hi

Create a table as below, and call it Stocks

A B C
Balance -20

Stock Code Units
A 1 250
A 1 -100
A 1 -100
A 1 -50
A 2 300
A 2 -30
A 2 -80
A 2 -150
A 2 -60

Name the
The formula in cell C2 should be =SUBTOTAL(109,Stocks[Units])

Then filter for Stock and code, and cell C2 will give the current balance