找回密码
 立即注册
搜索

请教各位大神出手

2
回复
779
查看
[复制链接]

2

主题

7

帖子

3

幻币

初入江湖

Rank: 1

积分
13
2021-11-19 11:53:00 显示全部楼层 |阅读模式
如何将以下公式写成自定义函数=MID(A1,MAX(IFERROR(FIND({"安尤","安障","一农场","安昌","三仙咀","安宏","唐家铺","三岔河","安化","安文","官当","官垱","安生","大杨树","安全","董家垱","理兴垱","安造","安福","安凝","焦圻","安金","安丰","出口洲","安裕","大鲸港","大京港","安康","下渔口","陈家咀","陈家嘴","安德","芦林铺","原种场","黄山头","城关","农科所","深柳","珊珀湖"},A1),)),3)
PPT学习论坛
回复

使用道具 举报

0

主题

4

帖子

0

幻币

东方不败

积分
-11
2022-2-14 00:43:12 显示全部楼层
这么数据的话做个对照表好一些吧!
PPT学习论坛
回复 支持 反对

使用道具 举报

0

主题

8

帖子

0

幻币

初入江湖

Rank: 1

积分
8
2022-2-18 05:55:30 显示全部楼层
大神,就想用自定义函数解决,望赐教!
PPT学习论坛
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册