excel一个单元格中有一串字符,知道该串字符中一定有几个字符属于已知字...答:=LOOKUP(,0/FIND({"WS","PL","WN","BL","LWN"},A2),{"WS","PL","WN","BL","LWN"})或 =LOOKUP(,0/COUNTIF(A2,"*"&{"WS","PL","WN","BL","LWN"}&"*"),{"WS","PL","WN","BL","LWN"})
excel怎么同时筛选两列数据?答:如何在excel中同时筛选多个指定数值? - : 假设你的数据在A5及A5以下,A4为表头(如“数量”),A1,A2,A3为空,在A2输入=OR(A5={568,897,654,895,156}) 里面的几个数是你要筛选出来的数据.再点数据菜单,筛选,高级筛选.数据区域选择 A4及下面的数据.条件区域选择 A1,A2.确定即可.Excel中多个命令...