wxsh.net
当前位置:首页>>关于excel中如何做全国省份和城市的下拉列表的资料>>

excel中如何做全国省份和城市的下拉列表

我把文件传上来,请点击这回答右下角绿色的“点击下载”按钮,下载文件看看效果。 方法一: 数据透视表的方法最为简单快捷...

你定义好了各省及其下属城市的名称了吗?如果定义好了,再看看单元格是不是常规型。在H2输入“=indirect($g2)”,当G2选择了省份后,H2就可以选择了。还要记得等号必须是英文状态的等号。

excel设置二级菜单下拉选择(省市选择列表)_百度经验 http://jingyan.baidu.com/article/48a42057c850dfa9242504c4.html

可以,请参考如下公式:=IF(COUNT(FIND({"北京","天津","河北","山西","内蒙古"},C33)),"华北",IF(COUNT(FIND({"辽宁","吉林","黑龙江"},C33)),"东北",IF(COUNT(FIND({"上海","江苏","浙江","安徽","福建","江西","山东"},C33)),"华东",IF(COUNT...

1.首先将“xx自治区”的换成“xx自治时:=SUBSTITUTE(A126,"区","省",1) 2.统一提出:=MID(C126,1,FIND("省",C126)) 3.最后再把“XX自治时的改回“XX自治区”

1.去掉合并单元格 2.工具 选项 自定义序列 做好自定义序列 3.数据 排序 选项 自定义序列

1、以C列为辅助列,在C2单元格输入以下公式,然后向下填充公式 =A2&B2 2、在E2单元格输入以下公式,然后向下填充公式 =SUMPRODUCT((A$2:A$7=D2)/COUNTIF(C$2:C$7,C$2:C$7)) 详见附图示例

如果地名都是xx省这样的就可以直接筛选,反之如果有一些数据不规范那就只能手工去修改名称以后再来筛

=IF(C2="","",IF(COUNT(FIND({"湖州","杭州","萧山","绍兴","宁波","临海","温州","金华","嘉兴"},C2)),"浙江省",IF(COUNT(FIND({"昆山","苏州","无锡","常州","南京","南通","泰州","淮安","徐州"},C2)),"江苏省",IF(COUNT(FIND({"芜湖","合肥"...

网站首页 | 网站地图
All rights reserved Powered by www.wxsh.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com