X二個 B2:D11{=TEXT(-SMALL(-RIGHT(SMALL(IF(MOD(SQRT(LEFT(SUBSTITUTE(SUBSTITUTE($A2&"X","X",ROW($1:$10)-1,1),"X",COLUMN($A:$J)-1,1),LEN($A2))),1)=0,LEFT(SUBSTITUTE(SUBSTITUTE($A2&"X","X",ROW($1:$10)-1,1),"X",COLUMN($A:$J)-1,1),LEN($A2)))+ROW($1:$10)*10^9,ROW($1:$10)*10),9),COLUMN(A1)),"0;;")
X單一 B2:D11{=IFERROR(SUBSTITUTE($A2,"X",SMALL(IF(MOD(SQRT(SUBSTITUTE($A2,"X",ROW($1:$10)-1)),1)=0,ROW($1:$10)-1),COLUMN(A1))),IF(COLUMN(A1)=1,"NP",""))
留言
張貼留言