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

Allocate value on FIFO basis

kumarlamba

New Member
Hi,
I have dates in "B column" and i have quantities in "C column".
I want to allocate value of "D4" cell from "C column" on the basis of dates (oldest to newest) i.e. FIFO basis, without sorting them.
 

Attachments

  • Book2.xlsx
    9.7 KB · Views: 7
Thanks for your reply.
Please refer this file.
Allocation of value in d4 should be on oldest to newest date basis.
I am using below formula, but it is not working when some values in column c are negative.
=MAX(0,MIN(C5,$D$4-SUMIF($B$5:$B$18,"<"&$B5,$C$5:$C$18)-SUMIF($B4:B$5,B5,$C4:C$5)))
 

Attachments

  • Book2 (2).xlsx
    10.4 KB · Views: 14
Back
Top