拆分每包数量 (10899)

F2{=INDEX(B:B,SMALL(IF(ROUNDUP($C$2:$C$6/$D$2:$D$6,)>=COLUMN(A:Z),ROW($2:$6),99),ROW(A1)))&""

G2=IFERROR(MIN(VLOOKUP(F2,B:D,2,)-COUNTIF(F$1:F1,F2)*VLOOKUP(F2,B:D,3,),VLOOKUP(F2,B:D,3,)),"")