有很多手机号码，写几个语句判断是否含有特殊号码，如后四位为AABB,ABAB,AAAB,ABBB,AAAA,ABCD
答案:2 悬赏:10 手机版
解决时间 2021-02-28 17:12
- 提问者网友：听门外雪花风
- 2021-02-28 07:33
有很多手机号码，写几个语句判断是否含有特殊号码，如后四位为AABB,ABAB,AAAB,ABBB,AAAA,ABCD
最佳答案
- 五星知识达人网友：雪起风沙痕
- 2021-02-28 07:43
假设手机号在A列，且为字符串格式存储，B2输入以下公式：
=IF(AND(TEXT(MId(A2,8,1)+1,"#")=MId(A2,9,1),TEXT(MId(A2,9,1)+1,"#")=MId(A2,10,1),TEXT(MId(A2,10,1)+1,"#")=MId(A2,11,1)),"ABCD",IF(AND(MId(A2,8,1)=MId(A2,9,1),MId(A2,9,1)=MId(A2,10,1),MId(A2,10,1)=MId(A2,11,1)),"AAAA",IF(AND(MId(A2,8,1)=MId(A2,9,1),MId(A2,10,1)=MId(A2,11,1)),"AABB",IF(AND(MId(A2,8,1)=MId(A2,10,1),MId(A2,9,1)=MId(A2,11,1)),"ABAB",IF(AND(MId(A2,8,1)=MId(A2,9,1),MId(A2,9,1)=MId(A2,10,1)),"AAAB",IF(AND(MId(A2,9,1)=MId(A2,10,1),MId(A2,10,1)=MId(A2,11,1)),"ABBB","CUSTOM"))))))
=IF(AND(TEXT(MId(A2,8,1)+1,"#")=MId(A2,9,1),TEXT(MId(A2,9,1)+1,"#")=MId(A2,10,1),TEXT(MId(A2,10,1)+1,"#")=MId(A2,11,1)),"ABCD",IF(AND(MId(A2,8,1)=MId(A2,9,1),MId(A2,9,1)=MId(A2,10,1),MId(A2,10,1)=MId(A2,11,1)),"AAAA",IF(AND(MId(A2,8,1)=MId(A2,9,1),MId(A2,10,1)=MId(A2,11,1)),"AABB",IF(AND(MId(A2,8,1)=MId(A2,10,1),MId(A2,9,1)=MId(A2,11,1)),"ABAB",IF(AND(MId(A2,8,1)=MId(A2,9,1),MId(A2,9,1)=MId(A2,10,1)),"AAAB",IF(AND(MId(A2,9,1)=MId(A2,10,1),MId(A2,10,1)=MId(A2,11,1)),"ABBB","CUSTOM"))))))
全部回答
- 1楼网友：山有枢
- 2021-02-28 08:05
这要写一个很长很长的公式了。
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯