<div class="wgt-best-mask">
<div class="wgt-answers-showbtn"><span class="wgt-best-arrowdown"></span>
</div>
</div>
<p>C1输入</p><p>=IF(COUNT(FIND($B$1:$B$4,A1)),A1,"")</p><p>数组公式先按住CTRL+SHIFT,最后回车使得编辑栏公式两端出现花括号{ }</p><p>公式下拉</p><p><a class="ikqb_img_alink" href="javascript:void(0)" target="_blank" title="点击查看大图"><img class="ikqb_img" esrc="https://gss0.baidu.com/-4o3dSag_xI4khGko9WTAnF6hhy/zhidao/wh%3D450%2C600/sign=56007ac121738bd4c474ba3594bbabe0/b812c8fcc3cec3fd70b7a269d988d43f87942724.jpg" src="https://gss0.baidu.com/-4o3dSag_xI4khGko9WTAnF6hhy/zhidao/wh%3D600%2C800/sign=3faf807df71986184112e7827add024b/b812c8fcc3cec3fd70b7a269d988d43f87942724.jpg"></a></p>
C1输入
=IF(COUNT(FIND($B$1:$B$4,A1)),A1,"")
数组公式,先按住CTRL+SHIFT,最后回车,使得编辑栏公式两端出现花括号{ }
公式下拉