导读 您好,现在蔡蔡来为大家解答以上的问题。根据多条件查找，急求 find函数能实现多条件的查找吗相信很多小伙伴还不知道,现在让我们一起来看看...
您好,现在蔡蔡来为大家解答以上的问题。根据多条件查找，急求 find函数能实现多条件的查找吗相信很多小伙伴还不知道,现在让我们一起来看看吧！
1、B1输入=IF(COUNT(FIND({"颈","肩","腿","腰","手","背"},A1)),MID(A1,MIN(IF(ISERROR(FIND({"颈","肩","腿","腰","手","背"},A1)),4^8,FIND({"颈","肩","腿","腰","手","背"},A1))),FIND("痛",A1)-MIN(IF(ISERROR(FIND({"颈","肩","腿","腰","手","背"},A1)),4^8,FIND({"颈","肩","腿","腰","手","背"},A1)))+1),"")回车并向下填充。
2、（公式很拗口！）Stcxj@126.com。
本文就为大家分享到这里，希望小伙伴们会喜欢。