首页 > 中学考试杂题 > 题目详情
解释下数组函数是什么含义｛=IF(ISERROR(IF(ROW()-6>COUNTIF(明细!$D$5:$D$200,$
题目内容：
解释下数组函数是什么含义
｛=IF(ISERROR(IF(ROW()-6>COUNTIF(明细!$D$5:$D$200,$L$5),"",INDEX(明细!$J$7:$J$200,SMALL(IF($L$5=明细!$D$7:$D$200,ROW(明细!$B$7:$B$200)-6),ROW(1:1))))),"",IF(ROW()-6>COUNTIF(明细!$D$5:$D$200,$L$5),"",INDEX(明细!$J$7:$J$200,SMALL(IF($L$5=明细!$D$7:$D$200,ROW(明细!$B$7:$B$200)-6),ROW(1:1)))))｝
解释下数组函数是什么含义
｛=IF(ISERROR(IF(ROW()-6>COUNTIF(明细!$D$5:$D$200,$L$5),"",INDEX(明细!$J$7:$J$200,SMALL(IF($L$5=明细!$D$7:$D$200,ROW(明细!$B$7:$B$200)-6),ROW(1:1))))),"",IF(ROW()-6>COUNTIF(明细!$D$5:$D$200,$L$5),"",INDEX(明细!$J$7:$J$200,SMALL(IF($L$5=明细!$D$7:$D$200,ROW(明细!$B$7:$B$200)-6),ROW(1:1)))))｝
｛=IF(ISERROR(IF(ROW()-6>COUNTIF(明细!$D$5:$D$200,$L$5),"",INDEX(明细!$J$7:$J$200,SMALL(IF($L$5=明细!$D$7:$D$200,ROW(明细!$B$7:$B$200)-6),ROW(1:1))))),"",IF(ROW()-6>COUNTIF(明细!$D$5:$D$200,$L$5),"",INDEX(明细!$J$7:$J$200,SMALL(IF($L$5=明细!$D$7:$D$200,ROW(明细!$B$7:$B$200)-6),ROW(1:1)))))｝
本题链接：