假定那50种数字在B1:B50,A2输入公式:=IF(A1="","",IF(COUNTIF(B1:B50,A1),"真","假"))如果只要是包含就显示真(如18与18W,18W包含18),公式改为这样:=IF(A1="","",IF(COUNTIF(B1:B50,"*"&A1&"*"),"真","假"))或者改为这样也行:=IF(A1="","",IF(COUNT(FIND(A1,B1:B50)),"真","假"))我把文件传上来,请点击这回答右下角绿色的“点击下载”按钮,下载文件看看效果...
|