S sambit Member Nov 26, 2021 #1 Sir, Please help to resolve the issue. The amount should be distributed as per First in First Out Basis. Example File is attached for your reference. Attachments Example File.xlsx 9.6 KB · Views: 15
Sir, Please help to resolve the issue. The amount should be distributed as per First in First Out Basis. Example File is attached for your reference.
B bosco_yip Excel Ninja Nov 26, 2021 #2 Result formula put in H4 then, In H4, formula copied down : =IF(VLOOKUP(B4,$I:$J,2,0)<=SUMIF(B$3:B3,B4,H$3:H3),"",IF(SUMIF(B$4:B4,B4,F$4:F4)<=VLOOKUP(B4,$I:$J,2,0),F4,VLOOKUP(B4,$I:$J,2,0)-SUMIF(B$3:B3,B4,H$3:H3)))
Result formula put in H4 then, In H4, formula copied down : =IF(VLOOKUP(B4,$I:$J,2,0)<=SUMIF(B$3:B3,B4,H$3:H3),"",IF(SUMIF(B$4:B4,B4,F$4:F4)<=VLOOKUP(B4,$I:$J,2,0),F4,VLOOKUP(B4,$I:$J,2,0)-SUMIF(B$3:B3,B4,H$3:H3)))
