请教,如何利用excel函数统计重复出现两次以上的数字是哪些?感谢!_百度...答:先计算哪些大于2次 TEXTJOIN(",",TRUE,IF(COUNTIF(A1:B3,A1:B3)>=3,A1:B3,""))再将上面公式替换红框内A1:A10 TEXTJOIN(",",TRUE,INDEX(IF(COUNTIF(A1:B3,A1:B3)>=3,A1:B3,""),MATCH(0,FREQUENCY(IF(COUNTIF(A1:B3,A1:B3)>=3,A1:B3,""),IF(COUNTIF(A1:B3,A1:B3)>=3,...