
已解决问题
谷歌虎背熊腰当爹啦用户在2012.10.17提交了关于“天门山excel **匹配”的提问,欢迎大家涌跃发表自己的观点。目前共有2个回答,最后更新于2025-01-04T23:00:20。表1:ABCD起始日期起始时间通话时长2012-03-3010:58:3400:01:462012-03-3011:22:0600:01:122012-03-3011:56:3700:00:532012-03-3014:03:0600:03:032012-03-3014:21:0400:00:152012-03-3014:29:2900:00:092012-03-3014:30:5000:00:162012-03-3014:37:5800:00:252012-03-3014:57:0600:00:152012-03-3015:03:1500:00:322012-03-318:10:4900:00:192012-03-318:12:4300:00:442012-03-318:16:1300:00:382012-03-319:07:5000:00:502012-03-319:10:1700:02:062012-03-319:31:3700:00:172012-03-3110:06:0800:01:052012-03-3110:11:3200:00:032012-03-3110:21:4400:03:01表二:ABC开始日期开始时间资费2012-3-3108:10:490.182012-3-3108:12:440.182012-3-3108:16:130.182012-3-3108:57:100.722012-3-3109:07:510.182012-3-3109:10:170.542012-3-3109:12:400.542012-3-3109:31:370.182012-3-3109:51:520.18首先匹配日期相同的,再在日期相同中匹配时间相同的,把表二c资费输出到表1D
希望大家能够帮助她。详细问题描述及疑问:
表1:ABCD起始日期起始时间通话时长2012-03-3010:58:3400:01:462012-03-3011:22:0600:01:122012-03-3011:56:3700:00:532012-03-3014:03:0600:03:032012-03-3014:21:0400:00:152012-03-3014:29:2900:00:092012-03-3014:30:5000:00:162012-03-3014:37:5800:00:252012-03-3014:57:0600:00:152012-03-3015:03:1500:00:322012-03-318:10:4900:00:192012-03-318:12:4300:00:442012-03-318:16:1300:00:382012-03-319:07:5000:00:502012-03-319:10:1700:02:062012-03-319:31:3700:00:172012-03-3110:06:0800:01:052012-03-3110:11:3200:00:032012-03-3110:21:4400:03:01表二:ABC开始日期开始时间资费2012-3-3108:10:490.182012-3-3108:12:440.182012-3-3108:16:130.182012-3-3108:57:100.722012-3-3109:07:510.182012-3-3109:10:170.542012-3-3109:12:400.542012-3-3109:31:370.182012-3-3109:51:520.18首先匹配日期相同的,再在日期相同中匹配时间相同的,把表二c资费输出到表1D
期待您的答案,希望你能感受到,我最真诚的谢意 !