Hi master,
This issue i'd post on chandoo.org but i haven't receive the latest reply for this issue.
So just want to seek for help in this forum, hope it will might help me.
This is the link for my post
'Bring Forward' stock formula in excel | Chandoo.org Excel Forums - Become Awesome in Excel
I don't know how to create a formula in excel to get an actual balance of stock referring the date and selected item.
The balance of pencil on 2nd jan is 100, because on 1st jan got in-stock 100.
Balance of the pencil on 20th apr is70, because at 4th and 19th feb there's deduction of 20 and 10.
Please help me. tq in advance.