如何將數量往下每20個編成1車 (14667)

(先)J2:J10{=MIN(TEXT(SUBTOTAL(9,OFFSET(C$2,,,ROW($1:$6)))-SUM(J$1:J1),"0;99;99")*1,20-MOD(SUM($J$1:J1),20))

G2:G10=IF(MOD(SUM(J$1:J1),20),"",MAX(G$1:G1)+1)

H2:I10{=OFFSET(A$1,MATCH(1=1,SUM($J$2:$J2)<=SUBTOTAL(9,OFFSET($C$2,,,ROW($1:$6))),),)