Excel 筛选、包含问题。求高手指教答:=IF((IFERROR(FIND(A1 & “,",D1& “,"),0))+(IFERROR(FIND(B1 ",",D1& “,"),0))+(IFERROR(FIND(C1& “,",D1& “,"),0)),1,0)
Excel使用技巧问题?答:这样吧:D2输入 =IF(ROW()<COUNTA(B:B)+1,IFERROR(VLOOKUP(B2,A:A,1,),""),INDEX(A:A,SMALL(IF(COUNTIF(B$1:B$100,A$1:A$100),4^8,ROW($1:$100)),ROW()-COUNTA(B:B)))&""数组公式,输入后...
if嵌套sum出错求助!答:=IF(OR(ISNUMBER(FIND({"忠实*","*跃进*","*黎明*","*自力*","*自立*","*上游*","*上尤*","*向阳*","*友谊*","*光辉*","*香花*"},O1))),"忠实胡","忠实彭")试下 ...