使用道具 举报
砂海 发表于 2012-5-8 17:17 =INDEX(a!$B$2:$B$285,SMALL(IF(a!$A$2:$A$285=$A$1,ROW($3:$286),65536),ROW(A1)))&"" 首行应该出不来.字 ...
zhh823543 发表于 2012-5-8 18:26 =INDEX(a!B:B,SMALL(IF(a!$A$2:$A$285=$A$1,ROW($2:$285),65536),ROW(A1)))&"",
lotte 发表于 2012-5-8 17:20 =INDEX(a!$B:$B,SMALL(IF(a!$A$2:$A$285=$A$1,ROW($2:$285),65536),ROW(A1)))&""
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-9-20 20:55 , Processed in 0.437651 second(s), 6 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.