使用道具 举报
爱疯 发表于 2015-8-4 22:02 =MID(INDIRECT("a"&(ROW(A1)-1)*8+3),5,2) =MID(OFFSET(A$1,2+(ROW()-1)*8,),5,2)
天天EP 发表于 2015-8-4 21:59 =MID(INDIRECT("A"&(8*(ROW()-1)+3)),5,2)
心正意诚身修 发表于 2015-8-4 20:25 =MID(INDIRECT(ADDRESS((ROW(A2)-1)*8+3,1,,,)),5,2)你试下。
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-4-24 22:26 , Processed in 0.373157 second(s), 11 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.