Excel用index函数为什么插入行,就显示错误?

2025-03-23 16:51:01
推荐回答(1个)
回答1:

=INDEX(A:A,SMALL(IF(MATCH(INDIRECT("A2:A101")&"",INDIRECT("A2:A101")&"",)=ROW(INDIRECT("2:101")),""),ROW(A1)))