EXCEL-代码-如何编写公式高手指教,弄了一宿有点迷糊了哈哈

aswyg1976 · 发表于 2011-4-2 06:44

A=="0FT","2FT","4FT","5FT","7FT","9FT","0BF","2BF","4BF","5BT","7BT","9BT","0BT","2BT","4BT","5BF","7BF',"9BF","1FT","3FT","6FT","8FT","1BT","3BT","6BF","8BF","1BF","3BF","6BT","8BT"
B===024579,024579,024579,024579,024579,024579,1368579,1368579,1368579,1368579,1368579,1368579,1368024,1368024,1368024,1368024,1368024,1368024,1368,1368,13-68,1368,02457913,02457913,02457913,02457913,02457968

用A相对应代入B的数值.如何编写公式

oyzhjr · 发表于 2011-4-2 07:35

LZ高笑了吧，A和B中的数据个数不一样，如何对应？

aswyg1976 · 发表于 2011-4-2 07:49

A=="0FT","2FT","4FT","5FT","7FT","9FT","0BF","2BF","4BF","5BT","7BT","9BT","0BT","2BT","4BT","5BF","7BF',"9BF","1FT","3FT","6FT","8FT","1BT","3BT","6BF","8BF","1BF","3BF","6BT","8BT"
B===024579,024579,024579,024579,024579,024579,1368579,1368579,1368579,1368579,1368579,1368579,1368024,1368024,1368024,1368024,1368024,1368024,1368,1368,1368,1368,02457913,02457913,02457913,02457913,02457968
用A相对应代入B的数值.如何编写公式
具体的就是如果A1=0FT 相应B1就显示024579
A2=4FT 相应B2 024579
A3=6BT B3 02457913
表达的有点问题,见谅.看看帮解决谢谢.

oyzhjr · 发表于 2011-4-2 07:57

A中是30个数据，B中是27个数据，你让我情何以堪？
没附件，我自己写了个，你看下是不是你要的。

[ 本帖最后由 oyzhjr 于 2011-4-2 08:01 编辑 ]

aswyg1976 · 发表于 2011-4-2 09:13

帮忙看看是这中格式的

NN001.rar (4.03 KB, 下载次数: 4)

		自动登录	找回密码
密码			免费注册

EXCEL-代码-如何编写公式高手指教,弄了一宿有点迷糊了哈哈

回复 2楼 oyzhjr 的帖子

能讲一下步骤吗? 谢了

EXCEL-代码-如何编写公式 高手指教,弄了一宿有点迷糊了哈哈

回复 2楼 oyzhjr 的帖子

能讲一下步骤吗? 谢了

EXCEL-代码-如何编写公式高手指教,弄了一宿有点迷糊了哈哈