Running total

[omnifit139]

Hi,

I have a column of part numbers (order lines,duplicates, sorted by date required), required quantities and actual on-hand.

How can I run down the list of part numbers (duplicates) and quantities, comparing ordered quantity to actual amount on-hand, and then subtracting the ordered quantity from the on-hand quantity, rolling forward the (new) subtotal to the next time the part number is found, and then perform the same calculation again?

omnifit139

 

[Akashwani]

Hi,

See if any of these videos help....


http://www.youtube.com/user/ExcelIsFun#p/search/34/Rr9dK5bDWcE

http://www.youtube.com/user/ExcelIsFun#p/search/0/KMnW0cII7CI

http://www.youtube.com/user/ExcelIsFun#p/search/8/9uUADN6hvHE

http://www.youtube.com/user/ExcelIsFun#p/search/12/cwIhkB4rVlw

http://www.youtube.com/user/ExcelIsFun#p/search/10/LnsfjyQtf6A


Good luck.

Ak

 

[omnifit139]

Thanks AK, I'll take a look...

omnifit139