A9{=INDEX(3:3,SMALL(IF(TEXT(MMULT({1,1,1},COUNTIF($H3:$J3,MID($A3:$F3,{1;2;3},1))),"[>2]*0;[<1]*0;0")<>"",COLUMN($A:$F),99),COLUMN(A2)))&""
另解{=INDEX(3:3,SMALL(IF(((MMULT({1,1,1},1-ISERR(FIND(TRANSPOSE($H3:$J3),$A3:$F3)))-1.5)^2=0.25)*MOD($A$3:$F$3,111),COLUMN($A:$F),99),COLUMN(A2)))&""
另解{=INDEX($3:$3,SMALL(IF(MMULT({1,1,1},COUNTIF($H$3:$J$3,MID($A$3:$F$3,{1;2;3},1)))={1;2},COLUMN($A:$F),99),COLUMN(A2)))&""
留言
張貼留言