我来回答
使用道具 举报
孤单无所谓 发表于 2019-1-10 11:56 =IFERROR(INDEX($A$3:$A$7,MATCH(SMALL(IF(COUNTIF($A$3:$C$7,$A$3:$A$7)=3,ROW($A$3:$A$7),""),ROW(A1)),I ...
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-3-29 03:57 , Processed in 0.569190 second(s), 11 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.