相隔數取數 依起止序號範圍內 (14636)

H4=REPT(ROW(A1),ROUNDUP((F$2-D$2)/E$2,)+1>=ROW(A1))

I4=IF(H4="","",OFFSET(B$3,MIN(D$2+(ROW(A1)-1)*E$2,F$2),))



留言