[已解决]求助论坛老师指导附件所述如何实现，谢谢！~

fywb2000

求助论坛老师指导附件所述如何实现，谢谢！~ 筛2.rar (7.82 KB, 下载次数: 9)

2014-12-12 22:12 上传

点击文件名下载附件

最佳答案

月排行榜 / 总排行榜

tgydslr

2014-12-12 22:52

B14=IF(COLUMN(A1)>COUNT(1/(COUNTIF($B8:$M8,OFFSET($B12,,,,COUNT($B12:$AW12)))=0)),"",SMALL(IF(COUNTIF($B8:$M8,OFFSET($B12,,,,COUNT($B12:$AW12)))=0,OFFSET($B12,,,,COUNT($B12:$AW12))),COLUMN(A1)))三键横拉

跳转到最佳答案楼层

xuyouxm

=INDEX($B$12:$AW$12,SMALL(IF(ISNA(MATCH($B$12:$AW$12,$B$8:$M$8,)),COLUMN($A:$AV),4^8),COLUMN(A1)))&""


=IF(ISERROR(INDEX($B$12:$AW$12,SMALL(IF(ISNA(MATCH($B$12:$AW$12,$B$8:$M$8,)),COLUMN($A:$AV),4^8),COLUMN(A1)))),"",INDEX($B$12:$AW$12,SMALL(IF(ISNA(MATCH($B$12:$AW$12,$B$8:$M$8,)),COLUMN($A:$AV),4^8),COLUMN(A1))))

tgydslr

B14=IF(COLUMN(A1)>COUNT(1/(COUNTIF($B8:$M8,OFFSET($B12,,,,COUNT($B12:$AW12)))=0)),"",SMALL(IF(COUNTIF($B8:$M8,OFFSET($B12,,,,COUNT($B12:$AW12)))=0,OFFSET($B12,,,,COUNT($B12:$AW12))),COLUMN(A1)))三键横拉

tgydslr

xuyouxm 发表于 2014-12-12 22:34
=INDEX($B$12:$AW$12,SMALL(IF(ISNA(MATCH($B$12:$AW$12,$B$8:$M$8,)),COLUMN($A:$AV),4^8),COLUMN(A1) ...

容错没做完整吧

fywb2000

感谢楼上的老师的指导，谢谢！~