函数公式优化

企鹅淹死

=IF(COUNT(FIND("维吾尔族",M5)),"维吾尔族",IF(COUNT(FIND("哈萨克族",M5)),"哈萨克族",IF(COUNT(FIND("回族",M5)),"回族",IF(COUNT(FIND("乌孜别克族",M5)),"乌孜别克族",IF(COUNT(FIND("柯尔克孜族",M5)),"柯尔克孜族",IF(COUNT(FIND("锡伯族",M5)),"锡伯族",IF(COUNT(FIND("满族",M5)),"满族",IF(COUNT(FIND("蒙古族",M5)),"蒙古族",IF(COUNT(FIND("达斡尔族",M5)),"达斡尔族",IF(COUNT(FIND("塔塔尔族",M5)),"塔塔尔族",IF(COUNT(FIND("俄罗斯族",M5)),"俄罗斯族",IF(COUNT(FIND("汉族",M5)),"汉族","其他"))))))))))))

奥妮克希亚

试试
=IFERROR(LOOKUP(,0/FIND({"维吾尔族","哈萨克族","回族","乌孜别克族",……},M5),{"维吾尔族","哈萨克族","回族","乌孜别克族",……}),"其他")

逆称

上传附件，这个问题很好处理的

阿哥爱篮球

最好上传附件，模似一下结果，大家看得更清楚