固定100~199{=COUNT(0/(MOD(ROW(100:199)+TRANSPOSE(ROW(100:199)),6)=0)/(ROW(100:199)>TRANSPOSE(ROW(100:199))))
D2{=COUNT(0/(MOD(ROW(INDIRECT(B2&":"&C2))+TRANSPOSE(ROW(INDIRECT(B2&":"&C2))),F$2)=0)/(ROW(INDIRECT(B2&":"&C2))>TRANSPOSE(ROW(INDIRECT(B2&":"&C2)))))
留言
張貼留言