最早入库累計日期 (11418)

J4=SUMIFS(I:I,G:G,G4,H:H,"<="&H4)

D4{=MIN(IF((G$4:G$20=B4)*(J$4:J$20>=C4),H$4:H$20))

無輔助{=LOOKUP(1,0/FREQUENCY(C4,SUMIFS(I:I,G:G,B4,H:H,"<="&H$4:H$499)),H$4:H23)

無輔助{=MIN(IF(SUMIFS(I:I,G:G,B4,H:H,"<="&H$4:H$499)>=C4,H$4:H$499))