201401函中班课前练习题06

路边的记忆

1. =TEXT(LOOKUP(,-FIND({0,"JHJD","JHZJ","JHBP","KSKS"},B2),{0,1,4,3,2}),"设计0部;;")

复制代码

微微简化一下

1. =TEXT(LOOKUP(,-FIND({0,0;"JHJD",1;"JHZJ",4;"JHBP",3;"KSKS",2},B2)),"设计0部;;")

复制代码

cgzxwwf

1. =IFERROR(CHOOSE(IFERROR(MATCH(999,FIND({"JHJD";"JHZJ";"JHBP";"KSKS"},B2)),""),"设计1部","设计4部","设计3部","设计2部"),"")

复制代码

air05

{:011:}帅哥学委我来交作业了

yorkchenshunan

=IF(ISNUMBER(FIND("JHJD",B2)),"设计1部",IF(ISNUMBER(FIND("JHZJ",B2)),"设计4部",IF(ISNUMBER(FIND("JHBP",B2)),"设计3部",IF(ISNUMBER(FIND("KSKS",B2)),"设计2部",""))))

ddmyykdzh

1. =IFERROR(INDEX({"设计1部","设计4部","设计3部","设计2部"},MATCH(MID(B2,22,4),{"JHJD","JHZJ","JHBP","KSKS"},)),"")

复制代码

满坛皆为吾师

1. =TEXT(MMULT(1-(ISERR(FIND({"HJ","SK","HB","HZ"},B2))),ROW($1:$4)),"设计0部;;")

复制代码

耗时许久，终于搞定，我做到我目前的极限了，过程中又体会到了点新东西。

1. =TEXT(MAX(COUNTIF(B2,"*"&{"HJ","HZ","HB","SK"}&"*")*{1,4,3,2}),"设计0部;;")

复制代码

第二条我在用COUNTIF的时候卡壳了非常久就跳过了，基础太弱，最后朋友指点的。

yqnh

参与学习
=IFERROR(TEXT(MATCH(,-FIND({"JHJ","KSK","JHB","JHZ"},B2)),"设计0部"),"")
数组

hsl215

1. =IFERROR(LOOKUP(,-FIND({"JHJD";"JHZJ";"JHBP";"KSKS"},B2),{"设计1部";"设计4部";"设计3部";"设计2部"}),"")

复制代码

回复的有点晚了

stone1969

=IF(COUNT(FIND(MID($B$1,ROW(INDIRECT("1:"&LEN($B$1))),1),B8))>=4,"设计1部",IF(COUNT(FIND(MID($C$1,ROW(INDIRECT("1:"&LEN($C$1))),1),B8))>=4,"设计4部",IF(COUNT(FIND(MID($J$1,ROW(INDIRECT("1:"&LEN($J$1))),1),B8))>=4,"设计3部",IF(COUNT(FIND(MID($K$1,ROW(INDIRECT("1:"&LEN($K$1))),1),B8))>=4,"设计2部",""))))