作业帮谁能解释下这些函数的意思啊=IF(SUM(--(COUNTIF($A$1:$A$8,Sheet1!$A$1:$A$11)=0))>=ROW(3:3),INDEX(Sheet1!$A$1:$A$11,SMALL(IF(COUNTIF($A$1:$A$8,Sheet1!$A$1:$A$11)=0,ROW(Sheet1!$A$1:$A$11)),ROW(3:3))),"")
来源：学生作业帮助网 编辑：作业帮 时间：2024/12/02 02:19:54
xRN@ 6 BJGB#n5!qeE
,ã(D Dҟ+)
+6l59̹qƼޫ%R4:RXHul4$[&b W ODٍ%G0@7?'Wpk@wX Ǝ_ǂPtoYxD&,X=DC.ֵ)c.M
G V \cqL#E$.]HC.֠VR{0Ro/@;R69[S$g% g DʐyS' o_ LVJ%n; ;SxL䱄4X 5Cæ%Pyyө /Ah
谁能解释下这些函数的意思啊=IF(SUM(--(COUNTIF($A$1:$A$8,Sheet1!$A$1:$A$11)=0))>=ROW(3:3),INDEX(Sheet1!$A$1:$A$11,SMALL(IF(COUNTIF($A$1:$A$8,Sheet1!$A$1:$A$11)=0,ROW(Sheet1!$A$1:$A$11)),ROW(3:3))),"")
谁能解释下这些函数的意思啊
=IF(SUM(--(COUNTIF($A$1:$A$8,Sheet1!$A$1:$A$11)=0))>=ROW(3:3),INDEX(Sheet1!$A$1:$A$11,SMALL(IF(COUNTIF($A$1:$A$8,Sheet1!$A$1:$A$11)=0,ROW(Sheet1!$A$1:$A$11)),ROW(3:3))),"")
谁能解释下这些函数的意思啊=IF(SUM(--(COUNTIF($A$1:$A$8,Sheet1!$A$1:$A$11)=0))>=ROW(3:3),INDEX(Sheet1!$A$1:$A$11,SMALL(IF(COUNTIF($A$1:$A$8,Sheet1!$A$1:$A$11)=0,ROW(Sheet1!$A$1:$A$11)),ROW(3:3))),"")
工具,公式审核,求值
一步步的看,多看几遍就明白了
这个公式的目的是把
sheet1的A1：A11中有而本表A1：A8中没有的应用过来.
公式很长,其实用操作,高级筛选,也很方便