问题已解决
excel表中請問如何用函數(shù)找出一列數(shù)據(jù)中的重復(fù)項(xiàng)
![](https://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/009/26/73/64_avatar_middle.jpg?t=1651203238)
您好,如果數(shù)據(jù)在A欄=IF(COUNTIF($A$2:$A$10,$A$2:$A$10)>1,重復(fù),不重復(fù))
2019 08/05 11:54
![](https://pic1.acc5.cn/009/26/73/64_avatar_middle.jpg?t=1651203238)
張蓉老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 08/05 11:55
您好,注意重復(fù)和不重復(fù)上面有冒號(hào),網(wǎng)站原因發(fā)出來不顯示冒號(hào)=IF(COUNTIF($A$2:$A$10,$A$2:$A$10)>1,重復(fù),不重復(fù))
FAILED
![](/wenda/img/newWd/sysp_btn_eye.png)