一區格數與提出數 (11171)


C2=IF(E$6<MOD(ROW(A1)-1,E$2)+1,"",OFFSET(A$2,INT((ROW(A1)-1)/E$2)*E$6+MOD(ROW(A1)-1,E$2),)&"")


另解=IF(E$6<MOD(ROW(A1)-1,E$2)+1,"",OFFSET(A$1,COUNTIF(C$1:C1,"><"),)&"")


留言