=SUMPRODUCT(1/COUNTIF(INDIRECT("A1:A"&COUNTA(A:A)),INDIRECT("A1:A"&COUNTA(A:A))))
使用道具 举报
如果数据在A列,
=INDEX($A$1:$A$10,SMALL(IF($A$1:$A$10<>"",IF(ROW($A$1:$A$10)=MATCH($A$1:$A$10,$A$1:$A$10,0),MATCH($A$1:$A$10,$A$1:$A$10,0))),ROW(A1)))
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-6-4 01:05 , Processed in 0.240364 second(s), 7 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.