用公式：=IF(OR(ISNUMBER(FIND(IF(B:B=""," ",B:B),A1))),"是","")数组公式，按CTRL+SHIFT+回车完成公式。
=COUNTIF(B:B,A1)如果数据大于0，则包括
=IF(B2="","",IF(ISNUMBER(FIND(B2,A2)),"是",""))
