隔行數自動計數 (13237)

E1下拉=IF((MOD(ROW(A1),B$7)<>1)+(ROW(A1)>B$3*B$7),"","第( "&TEXT(INT((ROW(A1)-1)/B$7)+1,0&0)&" )箱")



留言