本帖最后由 pcl_test 于 2016-8-11 16:14 编辑
我有一个Excel,D列 E列分别是数字和器件,如下图:25 | L11, L12, L13, L24, L28, R173,
R386A, R451, R711, L66, R3,
R99, R113, R154, R156, R178, R213, R382, R374, R125, R386, R387, L29, R297, R282 | 2 | R350,R351 | 21 | R28, R29, R33, R48, R51, R54, R80, R85, R133, R135, R136, R137, R139, R140, R141, R142, R143, R146, R284, R753, R230 | 5 | R75,R102,R394,R74,R97, | 12 | R150, R170, R181, R201, R203, R205, R217, R219, R220, R223, R124, R126 | 13 | R92, R123, R130, R131, R132, R81, R83, R84, R90, R91, R433, R504, R505 |
那我想做一个批处理计算E列中的器件总数和D列的数值是否相同,如果不同就暂停执行批处理,并把错误行告知。
我的想法是计算E列中的逗号数+1与D列数值比较,但具体怎么做却没办法,请高手指点一下! |