谁能解释下这些函数的意思啊=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))),"")

谁能解释下这些函数的意思啊=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中没有的应用过来.
公式很长,其实用操作,高级筛选,也很方便