企鹅淹死 发表于 2021-10-24 22:02:00

函数公式优化

=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)),"汉族","其他"))))))))))))

奥妮克希亚 发表于 2021-11-17 06:33:19

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

逆称 发表于 2022-1-6 12:38:44

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

阿哥爱篮球 发表于 2022-1-12 12:06:49

最好上传附件，模似一下结果，大家看得更清楚
页: [1]
查看完整版本: 函数公式优化