#1
|
|||
|
|||
Stock Balance by item and date
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. |
#2
|
|||
|
|||
A possible solution on added sheets
|
#3
|
|||
|
|||
Million thanks! You are awesome!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Keep balance column empty if no amount entered | baes10 | Excel | 3 | 08-14-2018 06:31 AM |
Copying data related to one item to worksheet with many instances of the same item | nmp13 | Excel | 3 | 02-06-2016 02:13 AM |
Don't Balance Columns for Continuous Section Starts | titani2 | Word | 1 | 01-25-2015 01:11 PM |
How to know the outstanding balance amount of a Loan? | PRADEEPB270 | Excel | 1 | 01-07-2012 04:45 AM |
Balance from different sheets | andre | Excel | 0 | 11-29-2011 02:36 PM |