I have a table set up similar to the on below:
Date| Starting Balance | Quantity Received | Quantity Used | New Balance
The new balance is the starting balance for the next row.
So for Row 1... The formula is
Starting Balance + Quantity Received - Quantity Used = New Balance
For Row 2 to End for each part it is
Previous Lines New Balance + Quantity Received - Quantity Used = New Balance
I think you can do this by adding a rank row and some Case Statements but I am getting my self wrapped around the Axle.
Any help will be appreciated.