201401函中班课前练习题06

26759761@qq.com

答案以代码方式提交就行了.

仅落恩

占楼  下班回家  晚上再做


=TEXT(IF(IFERROR(FIND("JHJD",B3),0),1,IF(IFERROR(FIND("JHZJ",B3),0),4,IF(IFERROR(FIND("JHBP",B3),0),3,IF(IFERROR(FIND("KSKS",B3),0),2,"")))),"设计0部")

智商不够 只能一个个套了

E界白菜

先来个长的

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

复制代码

cbg2008

=TEXT(SUM(COUNTIF(B2,"*"&{"JHJD";"KSKS";"JHBP";"JHZJ"}&"*")*ROW($1:$4)),"设计0部;;;")

chh0926

=REPT("设计1部",NOT(ISERR(FIND("JHJD",B2))))&REPT("设计4部",NOT(ISERR(FIND("JHZJ",B2))))&REPT("设计3部",NOT(ISERR(FIND("JHBP",B2))))&REPT("设计2部",NOT(ISERR(FIND("KSKS",B2))))

蝶·舞

1. =TEXT(5-MATCH(,0/FIND({"JHZJ","JHBP","KSKS","JHJD",""},B2),),"设计0部;;")

复制代码

AmoKat

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

ANDY0393

1. =IFERROR(TEXT(INT(FIND(MID(B2,FIND("/",B2)+IF(LEN(B2)>31,9,2),4),"JHJDKSKSJHBPJHZJ")/4+1),"设计0部"),"")

复制代码

tgydslr

=IFERROR(TEXT(LOOKUP(,-FIND({"JHJD","JHZJ","JHBP","KSKS"},B2),COLUMN(A:D)),"设计0部"),"")

MCQUEEN

1. =IF(ISNUMBER(FIND("JHJD",B2)),"设计1部",IF(ISNUMBER(FIND("JHZJ",B2)),"设计4部",IF(ISNUMBER(FIND("JHBP",B2)),"设计3部",IF(ISNUMBER(FIND("KSKS",B2)),"设计2部",""))))
   
2. =IFERROR(LOOKUP(9^9,FIND({"JHJD","KSKS","JHBP","JHZJ"},B2),"设计"&ROW($1:$4)&"部"),"")
   
3. =IFERROR(LOOKUP(9^9,FIND({"JHJD","KSKS","JHBP","JHZJ"},B2),{"设计1部","设计2部","设计3部","设计4部"}),"")
   
4. =IFERROR(INDEX("设计"&ROW($1:$4)&"部",MATCH(,FIND({"JHJD","KSKS","JHBP","JHZJ"},B2),-1)),"")
   

复制代码