=IF(ISERROR(SUM(1*SUBSTITUTE(A1,ROW(A1:A10)-1,"x",2))),"有重复数","没重复数")
这是一个数组公式,输入完成后要按Ctrl+Shift+Enter...=IF(COUNT(SEARCH({"0*0","1*1","2*2","3*3","4*4","5*5","6*6","7*7","8*8","9*9"},A1))>0,"有重复数","没重复数")...或者:
=IF(COUNT(SEARCH(REPT({0,1,2,3,4,5,6,7,8,9}&"*",2),A1))>0,"有重复数","没重复数")
下面的公式运用了一个数学公式,有兴趣的可以自己体会...(A1),"没重复数","有重复数")
这是一个数组公式,输入完成后要按Ctrl+Shift+Enter组合键。...("1:" &LEN(A1))),1)={0,1,2,3,4,5,6,7,8,9})))>1,"有重复数","没重复数")
这是一个数组公式,输入完成后要按Ctrl+Shift+Enter组合键。