• 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.

Calculation of Stock Qty, Rate, Supplier based on FIFO

TPR
from Your side
It has been a monologue
and You're still refer to old file.
Could You once answer ... what is missing?
 
TPR
from Your side
It has been a monologue
and You're still refer to old file.
Could You once answer ... what is missing?
Dear Sir,
First of all am not an actor, a house wife & an employee, hence if you think it is a monologue, then I feel proud to be an actor as in my country actors earn huge amount. (LOL)
Second, I stated multiple times what result I need. I need not any more column or date. Refer post #24. In that file I stated three types of data as criteria & their result. I need exactly that result.
 
TPR
Your I need exactly that result.
... then You can use exactly those results which You have solved Yourself. Keep those as fixed.
If You need something then
You should also be ready to give something.
I tried to give even more.

For me, this seems to be monologue - You couldn't give an answer for me.
 
TPR
Your I need exactly that result.
... then You can use exactly those results which You have solved Yourself. Keep those as fixed.
If You need something then
You should also be ready to give something.
I tried to give even more.

For me, this seems to be monologue - You couldn't give an answer for me.
But result is not coming Sir. I gave a screenshot of your file when I changed criteria data. Even when I am changing fruit then also result is coming wrong. I don't know what am I mistaking.
 
TPR
You continue as You've done ...
You have skipped even those two replies which I left.
the 1st was about mess
the 2nd was my the final version which ... You seems also skipped ... if so then okay ... I'll refer only with my the final versio.

> Your I need exactly that result is below ... nothing more ... as You've written with Your #30 reply <
TPR desired results.png

Have a Sunny day in Kolkata and take care.
 
1] Here is a formula solution in calculation of Stock Qty based on FIFO

64815

2] See attachment and please click H3 and I3 dropdown list to change the Fruit name and Qty for checking.

Regards
Bosco
 

Attachments

  • Calculation of Stock Qty based in FIFO.xlsx
    14.7 KB · Views: 24
Back
Top