F2:F16{=OFFSET(B$2,SMALL(IF(MMULT(1-ISERR(FIND(D$2,T(OFFSET(B$1,(ROW($1:$9)-1)*D$5+TRANSPOSE(ROW(INDIRECT("1:"&D$5))),)))),ROW(INDIRECT("1:"&D$5))^0),ROW($1:$9),99),INT((ROW(A1)-1)/D$5)+1)*D$5-D$5+MOD(ROW(A1)-1,D$5),)&""
格式化 依一區格數 分區 B2:B16=MOD(INT((ROW(A1)-1)/D$5),2)=1
格式化 B2:B16=FIND(D$2,B2)
H2{=REPT(ROW(A1),(MOD(ROW(A1),D$5)=1)*(COUNT(FIND(D$2,OFFSET(B2,,,D$5)))>0))
I2=OFFSET(B$1,SMALL(IF(H$2:H$16<>"",H$2:H$16*1,99),INT((ROW(A1)-1)/D$5)+1)+MOD(ROW(A1)-1,D$5),)&""
留言
張貼留言