判斷是否重複 (14680)

B2=IF(SUMPRODUCT((MMULT(1-ISERR(FIND(MID(A2,COLUMN(A:I),1),A$2:A$9)),ROW(1:9)^0)=9)*(LEN(A2)=LEN(A$2:A$9)))>1,"是","X")

另解=IF(SUMPRODUCT((MMULT(COUNTIF(A7,"*"&MID(A$2:A$9,COLUMN(A:I),1)&"*"),ROW(6:14)^0)=9)*(LEN(A$2:A$9)=LEN(A7)))>1,"是","否")