• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

STOCK BALANCE FORMULA BY SELECTED ITEM AND DATE

Status
Not open for further replies.

yande

New Member
Hi Master,

I don't know how to create a formula in excel to get an actual balance of stock referring the date and selected item.
Attached is the file of example of my work.

63452

Please help me.
Thanks in advance.
 

Attachments

yande

New Member
Hi master,

The result should be like this.
63455
For example, the balance of pencil on 2nd jan was 100, because on 1st jan got in-stock 100.
Balance of the pencil on 20th apr was 70, because at 4th and 19th feb there's deduction of 20 and 10.
 
Last edited:

vletm

Excel Ninja
yande
Is this this same as above written?
If not then write Your reply to that other thread to get this open again.
This is closed now.
 
Status
Not open for further replies.
Top