三个公式,记住,绝对引用。。。
IF(ISNUMBER(FIND($C$1:$C$3,A1)),"有","无")
IF(SUM(COUNTIF(A2,"*"&C$2:C$4&"*")),"有","无")
IF(COUNT(FIND(C$2:C$4,A2)),"有","无")
三个公式,记住,绝对引用。。。
IF(ISNUMBER(FIND($C$1:$C$3,A1)),"有","无")
IF(SUM(COUNTIF(A2,"*"&C$2:C$4&"*")),"有","无")
IF(COUNT(FIND(C$2:C$4,A2)),"有","无")
发表评论