excel太大,运行缓慢该怎么办答:=IF(ISERROR(VLOOKUP("龙逸凡",$A$2:$C$1000,3,0)),"查无此人",VLOOKUP("龙逸凡",$A$2:$C$1000,3,0))如果表格A2:A1000中有“龙逸凡”, 使用上面这个公式,则 Excel 要运算VLOOKUP函数两次。Excel 2007以后的版本中,可以使用 IFERROR 来减少运算的次数:=IFERROR(VLOOKUP("龙逸凡",$...
Excel如何比较两列数据并在新列中显示答:G2输入数组公式 =IF(ISERROR(INDEX(A$2:A$9,SMALL(IF(COUNTIF(C$2:C$11,A$2:A$9)=0,ROW(A$2:A$9)-1,8^8),ROW(A1))),"",INDEX(A$2:A$9,SMALL(IF(COUNTIF(C$2:C$11,A$2:A$9)=0,ROW(A$2:A$9)-1,8^8),ROW(A1)))以同按CTRL+SHIFT+回车 这三个键作为结束...
excel满足多个条件显示需要的内容答:假定首个输入公式的单元格在A列 在A23输入 =IFERROR(IF(A21=A22,LOOKUP(A21,{1,2,3},{"体育","数学","英语"}),"单"&LOOKUP(A21,{1,2,3},{"体育","数学","英语"})&"双"&LOOKUP(A22,{1,2,3},{"体育","数学","英语"})),"")或 =IF(OR(A21="",A22=""),"",IF(A21...