自己标记一个
=IF(COUNT(FIND({130,131,132,145,155,156,185,186},C2)),"联通",IF(COUNT(FIND({134,135,136,137,138,139,147,150,151,152,157,158,159,182,183,184,187,188},C2)),"移动",IF(COUNT(FIND({133,153,180,181,189},C2)),"电信","其他")))
自己标记一个
=IF(COUNT(FIND({130,131,132,145,155,156,185,186},C2)),"联通",IF(COUNT(FIND({134,135,136,137,138,139,147,150,151,152,157,158,159,182,183,184,187,188},C2)),"移动",IF(COUNT(FIND({133,153,180,181,189},C2)),"电信","其他")))