EXCEL中如何根据筛选出,A列中包含字符串B或C或D或E等等的行答:在B2单元格输入以下公式,然后向下填充公式 =IF(OR(ISNUMBER(FIND("B",A2)),ISNUMBER(FIND("C",A2)),ISNUMBER(FIND("D",A2))),"包含","")然后筛选B列中“包含”的行。公式中的"B","C","D"自行修改为需要的字符串。
EXCEL函数:如果A列同时包含A,B,C,D,E,F,G,H,那么黄色位置上面显示正确...答:E2输入 =IF(SUMPRODUCT(N(COUNTIF(A2:A11,{"A","B","C","D","E","F","G","H"})>=1))=8,"正确","错误")数组公式,先按住CTRL+SHIFT,最后回车