EXCLE表格筛选单元格内是否包含另外单元格内容
发布网友
共1个回答
热心网友
B2公式右拉：
=IF(B1="","",IF(ISERR(FIND(B1,$A1)),"否","是"))
或者用这公式也行：
=IF(B1="","",IF(COUNTIF($A1,"*"&B1&"*"),"是","否"))
