jchewsmith
Technical User
How can I do the following?:
Date Item run qty produced Remaining
1/1/2010 1234 1 500 250
2/10/2011 1234 2 1000 1000
3/1/2012 1234 3 3000 3000
Total on Hand = 4,250
I want to create the remaining column with a formula based on total on hand less qty produced start with the current and working backwards.
Date Item run qty produced Remaining
1/1/2010 1234 1 500 250
2/10/2011 1234 2 1000 1000
3/1/2012 1234 3 3000 3000
Total on Hand = 4,250
I want to create the remaining column with a formula based on total on hand less qty produced start with the current and working backwards.