ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Stock Calculation (https://www.excelbanter.com/excel-worksheet-functions/233862-stock-calculation.html)

Shah Alam

Stock Calculation
 
Suppose,
ProductionDate Production Op Balance DelDate Party Qnty Cl.
Balance
1.1.09 500 500 2.1.09
Leon 300 200
2.1.09 500 700 -----
---- ---- 700
3.1.09 500 1200 ------
---- 1200
4.1.09 ---- 1200 4.1.09
David 500 700
5.1.09 --- 700 5.1.09
Mahi 300 400

Note that in case of only DelDate that follows by Production date.

Thanks


Fred Smith[_4_]

Stock Calculation
 
What's the question?

Regards,
Fred.

"Shah Alam" <Shah wrote in message
...
Suppose,
ProductionDate Production Op Balance DelDate Party Qnty
Cl.
Balance
1.1.09 500 500 2.1.09
Leon 300 200
2.1.09 500 700 -----
---- ---- 700
3.1.09 500 1200 ------
---- 1200
4.1.09 ---- 1200 4.1.09
David 500 700
5.1.09 --- 700 5.1.09
Mahi 300 400

Note that in case of only DelDate that follows by Production date.

Thanks




All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com