问题描述:
求问一个EXCEL函数意义.
=IF(ROW(A1)>D$2,"",INDEX(A:A,MATCH(LARGE(IF((B$2:B$100>0)*(B$2:B$100>=LARGE(B$2:B$100,D$2)),B$2:B$100-ROW($2:$100)/10^8,),ROW(A1)),B$2:B$100-ROW($2:$100)/10^8,)+1))
=IF(ROW(A1)>D$2,"",INDEX(A:A,MATCH(LARGE(IF((B$2:B$100>0)*(B$2:B$100>=LARGE(B$2:B$100,D$2)),B$2:B$100-ROW($2:$100)/10^8,),ROW(A1)),B$2:B$100-ROW($2:$100)/10^8,)+1))
问题解答:
我来补答展开全文阅读