=IF(COUNTIF(B:B,A1)=0,"",A1)
可以用COUNTIF函数，如：=IF(COUNTIF(B:B,A1),A1,"")
=IF(COUNTIF(B:B,A1),A1,"")或者=IF(COUNTIF(B:B,A1)>0,A1,"")
