導(dǎo)讀 您好,現(xiàn)在蔡蔡來為大家解答以上的問題。根據(jù)多條件查找，急求 find函數(shù)能實(shí)現(xiàn)多條件的查找嗎相信很多小伙伴還不知道,現(xiàn)在讓我們一起來看看...
您好,現(xiàn)在蔡蔡來為大家解答以上的問題。根據(jù)多條件查找，急求 find函數(shù)能實(shí)現(xiàn)多條件的查找嗎相信很多小伙伴還不知道,現(xiàn)在讓我們一起來看看吧！
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。
本文就為大家分享到這里，希望小伙伴們會(huì)喜歡。