裝箱 剩餘數與平均差距最小 (14433)

C3:H8{=TEXT(MIN($B3-(99-RIGHT(MAX((MOD($B3-1,ROW($9:$24))+1)/1%-ROW($9:$24)+99),2))*(COLUMN(A1)-1),99-RIGHT(MAX((MOD($B3-1,ROW($9:$24))+1)/1%-ROW($9:$24)+99),2)),"0;;")