我只匹配QQ与163的邮箱,类似这样
GREPARRAY(SPLIT(a2,","),REGEXP(item,"^[\\w-]+(\\.[\\w-]+)*(@qq.com|@163.com)$"))
count(GREPARRAY(SPLIT(a2,","),REGEXP(item,"^[\\w-]+(\\.[\\w-]+)*(@qq.com|@163.com)$")))=count(split(a2,","))
--------相对通用一点的。你继续增加域名的后缀-------
GREPARRAY(SPLIT(A3,","),REGEXP(item,"^[0-9a-zA-Z_]{0,19}@[0-9a-zA-Z]{1,13}\\.[com,cn,net]{1,3}$"))