Office中国论坛/Access中国论坛

标题: 如何在Excel中进行有规则的转换 [打印本页]

作者: 热线 时间: 2007-2-21 21:10
标题: 如何在Excel中进行有规则的转换
有下面数据：
33030031330101
30101133013001
.
.
.

条件是：

将第一列和第二列组合成0-8中的一个数，第三列和第四列组合成0-8中的一个数，第五列和第六列组合成0-8中的一个数，第七列和第八列组合成0-8中的一个数，第九列和第十列组合成0-8中的一个数，第十一列和第十二列组合成0-8中的一个数，第十三列和第十四列组合成0-8中的一个数。

转换规则如下：
33=0 31=1 30=2 13=3 11=4 10=5 03=6 01=7 00=8

转换后的数据变为：
0681077
1540727
.
.
.

谢谢！

作者: cola 时间: 2007-2-22 02:42
=(MATCH(MID(A1,1,2),{"33","31","30","13","11","10","03","01","00"},0)-1)&(MATCH(MID(A1,3,2),{"33","31","30","13","11","10","03","01","00"},0)-1)&(MATCH(MID(A1,5,2),{"33","31","30","13","11","10","03","01","00"},0)-1)&(MATCH(MID(A1,7,2),{"33","31","30","13","11","10","03","01","00"},0)-1)&(MATCH(MID(A1,9,2),{"33","31","30","13","11","10","03","01","00"},0)-1)&(MATCH(MID(A1,11,2),{"33","31","30","13","11","10","03","01","00"},0)-1)&(MATCH(MID(A1,13,2),{"33","31","30","13","11","10","03","01","00"},0)-1)

作者: 热线 时间: 2007-2-22 03:36
谢谢祝cola新年快乐

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)