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)))&"""""

原文：https://www.cnblogs.com/xupanfeng/p/11241860.html