excel删除重复值

0o笑笑宝贝o0 2023-03-19 17:33

• 

  ___丶自甴

  2023-03-19 18:06

  见截图

  B1输入

  =INDEX(A:A,SMALL(IF(MATCH($A$1:$A$10,$A$1:$A$10,)=ROW($1:$10),ROW($1:$10),100),ROW(A1)))&""

  数组公式，先按住CTRL+SHIFT,最后回车，使得编辑栏公式两端出现花括号{ }

  公式下拉到无数据

  追问如果需要处理的数据很多，就是A列很多数，我改公式哪啊？

  追答数据太多的话，如果不超过10000行，用下面公式=INDEX(A:A,SMALL(IF(MATCH($A$1:$A$10000,$A$1:$A$10000,)=ROW($1:$10000),ROW($1:$10000),4^8),ROW(A1)))&""

  比如数据在A列，B2输入 =IF(ISERROR(FIND(0,A2)),"","0")&IF(ISERROR(FIND(1,A2)),"","1")&IF(ISERROR(FIND(2,A2)),"","2")&IF(ISERROR(FIND(3,A2)),"","3")&IF(ISERROR(FIND(4,A2)),"","4")&IF(ISERROR(FIND(5,A2)),"","5")&IF(ISERROR(FIND(6,A2)),"","6")&IF(ISERROR(FIND(7,A2)),"","7")&IF(ISERROR(FIND(8,A2)),"","8")&IF(ISERROR(FIND(9,A2)),"","9")向下填充。

  =INDEX(B:B,SMALL(IF((MONTH($A$2:$A$100)=2)*(COUNTIF(INDIRECT("B$2:B$"&ROW(A$2:A$100)),$B$2:$B$100)=1),ROW(A$2:A$100),65536),ROW(A1)))下拉行数多时会比较慢(不用辅助列的结果，呵呵)
  0 讨论(0)
  发布评论:

  提交评论

  ---

  •  加载中...