数组公式无法下拉填充,我的公式错哪了?
=IF(ROW(A1)>COUNTIF($D$3:$D$1000,"二类"),"",INDEX(G:G,SMALL(IF($D$3:$D$1000="二类",ROW($3:$1000)),ROW(A1))))
ROW(A1)>COUNTIF($D$3:$D$1000,"二类")
这里ROW(A1)应该不变为1,一般用 if (COUNTIF($D$3:$D$1000,"二类"),...,"")
或者用iferror(...&"","")
改为:=IFERROR(INDEX(G:G,SMALL(IF($D$3:$D$1000="二类",ROW($3:$1000)),ROW(A1)))&"","")
热门标签: