ExcelHome技术论坛

 找回密码
 免费注册

QQ登录

只需一步,快速开始

快捷登录

搜索
EH技术汇-专业的职场技能充电站 妙哉!函数段子手趣味讲函数 Excel服务器-会Excel,做管理系统 Excel Home精品图文教程库
HR薪酬管理数字化实战 Excel 2021函数公式学习大典 Excel数据透视表实战秘技 打造核心竞争力的职场宝典
300集Office 2010微视频教程 数据工作者的案头书 免费直播课集锦 ExcelHome出品 - VBA代码宝免费下载
用ChatGPT与VBA一键搞定Excel WPS表格从入门到精通 Excel VBA经典代码实践指南
楼主: yusanfengyi

当年写的一个非常非常牛B的函数,到现在想想都想笑~

  [复制链接]

TA的精华主题

TA的得分主题

发表于 2019-6-14 14:13 | 显示全部楼层

TA的精华主题

TA的得分主题

发表于 2019-6-21 15:08 | 显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用  · 内置多项VBA编程加强工具       ★ 免费下载 ★      ★使用手册
骚噶!用牛B已经不能形容你们了

TA的精华主题

TA的得分主题

发表于 2021-1-13 14:23 | 显示全部楼层
=IF(K3="","",IF(COUNT(FIND("鞍山",K3)),"鞍山",IF(COUNT(FIND("白山",K3)),"白山",IF(COUNT(FIND("松原",K3)),"松原",IF(COUNT(FIND("延边",K3)),"延边",IF(COUNT(FIND("大连",K3)),"大连",IF(COUNT(FIND("本溪",K3)),"本溪",IF(COUNT(FIND("朝阳",K3)),"朝阳",IF(COUNT(FIND("丹东",K3)),"丹东",IF(COUNT(FIND("抚顺",K3)),"抚顺",IF(COUNT(FIND("阜新",K3)),"阜新",IF(COUNT(FIND("葫芦岛",K3)),"葫芦岛",IF(COUNT(FIND("锦州",K3)),"锦州",IF(COUNT(FIND("辽阳",K3)),"辽阳",IF(COUNT(FIND("辽源",K3)),"辽源",IF(COUNT(FIND("盘锦",K3)),"盘锦",IF(COUNT(FIND("沈阳",K3)),"沈阳",IF(COUNT(FIND("四平",K3)),"四平",IF(COUNT(FIND("铁岭",K3)),"铁岭",IF(COUNT(FIND("通化",K3)),"通化",IF(COUNT(FIND("营口",K3)),"营口",IF(COUNT(FIND("长春",K3)),"长春",IF(COUNT(FIND("吉林市",K3)),"吉林市",IF(COUNT(FIND("白城",K3)),"白城",IF(COUNT(FIND("辽宁",K3)),"沈阳",IF(COUNT(FIND({"呼和浩特","包头","乌海","赤峰","通辽","鄂尔多斯","呼伦贝尔","巴彦淖尔","乌兰察布","兴安盟","锡林郭勒","阿拉善","内蒙"},K3)),"内蒙",IF(COUNT(FIND("吉林",K3)),"四平","未识别")))))))))))))))))))))))))))

=IF(COUNT(FIND({"铁东区","铁西区","立山","千山","海城","台安","岫岩","鞍山"},L3)),"鞍山",IF(COUNT(FIND({"平山","溪湖","明山","南芬","本溪","桓仁"},L3)),"本溪",IF(COUNT(FIND({"双塔","龙城","北票","凌源","朝阳","建平","喀喇"},L3)),"朝阳",IF(COUNT(FIND({"西岗","中山","沙河口","甘井子","旅顺口","金州","瓦房店","普兰店","庄河","长海","经济技术开发区","大连"},L3)),"大连",IF(COUNT(FIND({"振兴","元宝区","振安","东港","凤城","宽甸","丹东"},L3)),"丹东",IF(COUNT(FIND({"顺城","新抚","东洲","望花","抚顺","新宾","清原"},L3)),"抚顺",IF(COUNT(FIND({"海州","新邱","太平","清河门","细河","彰武","阜新"},L3)),"阜新",IF(COUNT(FIND({"龙港","连山","南票","兴城","绥中","建昌","葫芦岛"},L3)),"葫芦岛",IF(COUNT(FIND({"太和","古塔","凌河","凌海","北镇","黑山","义县","锦州"},L3)),"锦州",IF(COUNT(FIND({"白塔","文圣","宏伟","弓长岭","太子河","灯塔","辽阳"},L3)),"辽阳",IF(COUNT(FIND({"兴隆台","双台子","大洼","盘山","盘锦"},L3)),"盘锦",IF(COUNT(FIND({"沈河","和平","大东","皇姑","铁西","苏家屯","东陵","沈北新区","于洪","新民","辽中","康平","法库","沈阳"},L3)),"沈阳",IF(COUNT(FIND({"银州","清河","调兵山","开原","西丰","昌图","铁岭"},L3)),"铁岭",IF(COUNT(FIND({"站前","西市","鲅鱼圈","老边","盖州","大石桥","营口"},L3)),"营口",IF(COUNT(FIND({"铁西区","铁东区","公主岭","双辽","梨树","伊通","四平"},L3)),"四平",IF(COUNT(FIND({"洮北","洮南","大安","镇赉","通榆","白城"},L3)),"白城",IF(COUNT(FIND({"八道江","江源","临江","抚松","靖宇","长白","白山"},L3)),"白山",IF(COUNT(FIND({"朝阳","南关","宽城","二道","绿园","双阳","德惠","九台","榆树","农安","长春"},L3)),"长春",IF(COUNT(FIND({"船营","昌邑","龙潭","丰满","蛟河","桦甸","舒兰","磐石","永吉","吉林市"},L3)),"吉林市",IF(COUNT(FIND({"龙山","西安","东丰","东辽","辽源"},L3)),"辽源",IF(COUNT(FIND({"宁江","长岭","乾安","扶余","前郭尔","松原"},L3)),"松原",IF(COUNT(FIND({"东昌","二道江","梅河口","集安","通化","辉南","柳河"},L3)),"通化",IF(COUNT(FIND({"延吉","图们","敦化","珲春","龙井","和龙","汪清","安图","延边"},L3)),"延边",IF(COUNT(FIND("吉林",L3)),"吉林省",IF(COUNT(FIND({"呼和浩特","包头","乌海","赤峰","通辽","鄂尔多斯","呼伦贝尔","巴彦淖尔","乌兰察布","兴安盟","锡林郭勒","阿拉善","内蒙"},L3)),"内蒙","未识别")))))))))))))))))))))))))

这俩公式躺在我的数据表里2年了

TA的精华主题

TA的得分主题

发表于 2021-1-17 14:50 | 显示全部楼层

TA的精华主题

TA的得分主题

发表于 2021-1-26 15:26 | 显示全部楼层
楼主:
        你这么牛B(IF大王),为何当时不申请吉尼斯?

TA的精华主题

TA的得分主题

发表于 2021-1-26 15:26 | 显示全部楼层
楼主:
        你这么牛B(IF大王),为何当时不申请吉尼斯?

TA的精华主题

TA的得分主题

发表于 2021-5-7 23:19 来自手机 | 显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用  · 内置多项VBA编程加强工具       ★ 免费下载 ★      ★使用手册
龙行九州 发表于 2013-9-26 09:28
MC21/MC12:

=IF(H3="铝板3",O3*L3,)&IF(H3="铝板2",O3*L3,)&IF(H3="铝型材TD34810224S",O3*L3,)&IF(H3= ...

眼镜都看了
您需要登录后才可以回帖 登录 | 免费注册

本版积分规则

手机版|关于我们|联系我们|ExcelHome

GMT+8, 2024-3-28 16:52 , Processed in 0.045861 second(s), 7 queries , Gzip On, Redis On.

Powered by Discuz! X3.4

© 1999-2023 Wooffice Inc.

沪公网安备 31011702000001号 沪ICP备11019229号-2

本论坛言论纯属发表者个人意见,任何违反国家相关法律的言论,本站将协助国家相关部门追究发言者责任!     本站特聘法律顾问:李志群律师

快速回复 返回顶部 返回列表