使用道具 举报
cabcyvr 发表于 2017-7-26 16:29 A2=批号 B2=任意数字 C2=IF(ISERROR(SEARCH(LEFT(A2,9)&"*"&RIGHT(A2,2),B2)),"",RIGHT(B2,2)&":"&IF(R ...
cabcyvr 发表于 2017-7-26 16:46 最后两位数 30 或 00 的规律是什么??
查看全部评分
cabcyvr 发表于 2017-7-26 16:55 D2=RIGHT(B2,2)&":"&MID("30003000",FIND(RIGHT(B2,2),"08131722"),2) “当B4批号为-**17 ,D2为16:30” ...
zyouong 发表于 2017-7-26 17:04 =lookup(--right(B2,2),{8,13,17,22},{"8:30","13:00","16:30","22:00"})
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-3-28 21:59 , Processed in 0.429795 second(s), 10 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.