指定行數 提取 (14338)

G2:H22{=INDEX(B:B,SMALL(IF(MOD(ROW($1:$98)-1,$E$2+$E$5)+1<=$E$2,ROW($2:$99),99),ROW(A1)))&""

B2:C22格式化=(MOD(ROW(A1)-1,$E$2+$E$5)+1<=$E$2)*(B2<>"")



留言