用Excel表格语句,对8位电话号筛选,尾号符合:AABB;ABAB;AAAA;AAAAA;A...答:6)否则为空 1.2公式:=IF(AND(C3=D3,D3=E3,E3=F3,F3=G3),"AAAAA",IF(AND(D3=E3,E3=F3,F3=G3),"AAAA",IF(AND(C3=D3,D3=E3,E3<>F3,F3=G3),"AAABB",IF(AND(D3=E3,F3=G3,E3<>F3),"AABB",IF(AND(D3=F3,E3=G3,E3<>F3),"ABAB","")))1.3 结果截图:...