EXCEL表 怎么找出 同一列 重复值

两种方法：

方法一：

方法二：
=IF(COUNTIF(A:A,A2)>1,"重复","")
via http://jingyan.baidu.com/article/39810a23e52983b636fda61f.html





Homepage

This website is encrypted and protected with SSL (Secure Sockets Layer).

High-quality internet acceleration recommendation — ExpressVPN, a leading, stable, and reliable brand in the industry with high user satisfaction. It does not keep activity logs, uses strong encryption, imposes no data limits, and offers a 30-day money-back guarantee.

Proudly partnered with SiteGround — fast, reliable, and secure WordPress hosting.