EXCEL去重函数

="INDEX(Sheet1!B:B,SMALL(IF(MATCH(Sheet1!$B$1:$B$"&COUNTA(Sheet1!B:B)&",Sheet1!$B$1:$B$"&COUNTA(Sheet1!B:B)&",)=ROW($1:$"&COUNTA(Sheet1!B:B)&"),ROW($1:$"&COUNTA(Sheet1!B:B)&"),4^8),ROW(A1)))&"""""

posted on 2019-07-25 04:23  土豆爸  阅读(1700)  评论(0编辑  收藏  举报

导航