Excel中 查找重复数据

  =IF(COUNTIF(A$1:A$300,A1)/COUNTIF(A1:A$300,A1)>1,"重复","不重复")

原文地址:https://www.cnblogs.com/ANLOG/p/3530783.html