|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 15th, 2009, 12:07 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
June 15th, 2009, 03:14 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
