本篇文章给大家谈谈excel筛选186，以及excel筛选18数位对应的知识点，希望对各位有所帮助，不要忘了收藏本站喔。
本文目录：
如何从EXCEL表格中筛选出来数据列中的手机号哪些是移动哪些是联通
=IF(LEFT(K2,3)="134","移动",IF(LEFT(K2,3)="135","移动",IF(LEFT(K2,3)="136","移动",IF(LEFT(K2,3)="137","移动",IF(LEFT(K2,3)="138","移动",IF(LEFT(K2,3)="139","移动",IF(LEFT(K2,3)="147","移动",IF(LEFT(K2,3)="150","移动",IF(LEFT(K2,3)="151","移动",IF(LEFT(K2,3)="152","移动",IF(LEFT(K2,3)="157","移动",IF(LEFT(K2,3)="158","移动",IF(LEFT(K2,3)="159","移动",IF(LEFT(K2,3)="182","移动",IF(LEFT(K2,3)="183","移动",IF(LEFT(K2,3)="187","移动",IF(LEFT(K2,3)="188","移动",IF(LEFT(K2,3)="178","移动",IF(LEFT(K2,3)="184","移动",IF(LEFT(K2,3)="198","移动",IF(LEFT(K2,3)="130","联通",IF(LEFT(K2,3)="131","联通",IF(LEFT(K2,3)="132","联通",IF(LEFT(K2,3)="155","联通",IF(LEFT(K2,3)="156","联通",IF(LEFT(K2,3)="185","联通",IF(LEFT(K2,3)="166","联通",IF(LEFT(K2,3)="175","联通",IF(LEFT(K2,3)="176","联通",IF(LEFT(K2,3)="186","联通",IF(LEFT(K2,3)="145","联通",IF(LEFT(K2,3)="133","电信",IF(LEFT(K2,3)="153","电信",IF(LEFT(K2,3)="180","电信",IF(LEFT(K2,3)="189","电信",IF(LEFT(K2,3)="181","电信",IF(LEFT(K2,3)="199","电信",IF(LEFT(K2,3)="173","联通",IF(LEFT(K2,3)="177","电信","")))))))))))))))))))))))))))))))))))))))
excel表格 高级筛选
在空白的地方 写=0.8 下面接着些=1
然后选中你的数据-数据-筛选-高级筛选-
条件里选择 空白地方些的那两个条件 就OK了
格式-条件格式 里设置颜色 0.8-1的数据
excel 算手机号段为186的人数
假设手机号码在A列，则在B1输入公式：
=SUM(IF(LEFT(A:A,3)="186",1))
按CTRL+SHIFT+回车
excel筛选186的介绍就聊到这里吧，感谢你花时间阅读本站内容，更多关于excel筛选18数位、excel筛选186的信息别忘了在本站进行查找喔。