Dear Friends,
Pls go through the attached file. Green Highlighted Area is basic Data. Blue highlighted are criteria & Yellow highlighted are desired Result.
What I need is formula for K3 to O3 and so on based on stock qty as on Date mentioned in J1.
The formula will stop when qty will reach equal to stock qty (J3).
Better to get formula rather than VBA
By default calculation would be FIFO basis. Pls note that Data may be or may not be in ascending or descending order in date column.
Please help.
Thanks in Advance
Regards
TPR
Pls go through the attached file. Green Highlighted Area is basic Data. Blue highlighted are criteria & Yellow highlighted are desired Result.
What I need is formula for K3 to O3 and so on based on stock qty as on Date mentioned in J1.
The formula will stop when qty will reach equal to stock qty (J3).
Better to get formula rather than VBA
By default calculation would be FIFO basis. Pls note that Data may be or may not be in ascending or descending order in date column.
Please help.
Thanks in Advance
Regards
TPR
Attachments

9.6 KB Views: 18