1.查找重复项 IF(COUNTIF(A:A,A1)>1”重复””") 或者 IF(COUNTIF($A$1:$A$100,A1)=1,"","重复") 转载于:https://www.cnblogs.com/jiaotashidi/p/6088604.html