質數 每100號取出 (14190)

A2:J27{=IFERROR(SMALL(IF(MMULT(N(ROUND(MOD(ROW($1:$99)+(COLUMN(A1)-1)/1%,TRANSPOSE(ROW(INDIRECT("1:"&COLUMN(A1)/1%-1)))),)=0),ROW(INDIRECT("1:"&COLUMN(A1)/1%-1))^0)=2,ROW($1:$99)+(COLUMN(A1)-1)/1%),ROW(A1)),"")



留言