【函高201501】第二讲B组作业上交贴
B组的朋友们：开秀答案了！符合题设、答案正确的多一种方法多一个奖励！
格式：
B+学号：
1。（法1~法N：）
2。（法1~法N：）
3。（法1~法N：）
4。（法1~法N：） 话说，可以交作业了。。。
B01:Excel学徒123
1、（法1、=INDEX(FREQUENCY(A8:A13,C8:C9),2)；法2、=FREQUENCY(A8:A13,{50;20})
2、（法1、=LARGE(IF(FREQUENCY(A18:A26,A18:A26),A18:A26,-9E+307),3)；法2、=LARGE((MATCH(A18:A26,A18:A26,)=ROW(1:9))*A18:A26,3)
3、（法1、=COUNT(0/FREQUENCY(IFERROR(--A30:C35,CODE(A30:C35)%),ROW(A:A)%))；法2、=COUNT(1/FREQUENCY(COUNTIF(A30:C35,">="&A30:C35)+ISTEXT(A30:C35)/1%,ROW(A:A)))
4、（法1、=IF(FREQUENCY(B40,{16;12}),"合格","不合格")；法2、=TEXT(FREQUENCY(B40,{16;12}),"合格;;不合格") B13：橙桔仔
1.法1=SUM(COUNTIF(A8:A13,{"<=50","<=20"})*{1,-1})法2=INDEX(FREQUENCY(A8:A13,{20,50}),2)法3=FREQUENCY(A8:A13,{50,20})2.=LARGE((FREQUENCY(A18:A26,A18:A26)>0)*A18:A27,3)3.=SUM(1/COUNTIF(A30:C35,A30:C35))4.=IF(FREQUENCY(B40,{16,12}),"合格","不合格") 我先手打一题 么么哒 其他的慢慢想
1、=frequency(a8:a13,c9)-frequency(a8:a13,c8) B01：
1、=INDEX(FREQUENCY(A8:A13,C8:C9),2)2、=LARGE(IF(FREQUENCY(A18:A26,A18:A26),A18:A26),3)3、数组公式：=COUNT(1/FREQUENCY(IF(ISTEXT(A30:C35),4^8+CODE(A30:C35),A30:C35),IF(ISTEXT(A30:C35),4^8+CODE(A30:C35),A30:C35)))4、法1：=INDEX(TEXT(FREQUENCY(B40,{12,16}),"合格;;不合格"),2)法2：=INDEX(IF(FREQUENCY(B40,{12,16}),"合格","不合格"),2) 老师辛苦了
B03:smuggled
第一题=INDEX(FREQUENCY(A8:A13,C8:C9),2)=FREQUENCY(A8:A13,{50,20})第二题=LARGE((FREQUENCY(A18:A26,A18:A26)>0)*A18:A27,3)第三题=COUNT(1/FREQUENCY(COUNTIF(A30:C35,">="&A30:C35)+ISTEXT(A30:C35)/1%,ROW(A:A)))第四题=IF(FREQUENCY(IF((B40:B44>12)*(B40:B44<=16),ROW(1:5)),ROW(1:4)),"合格","不合格") =IF(FREQUENCY(B40,{16,12}),"合格","不合格") 1<span style="line-height: 1.5;">=FREQUENCY(A8:A13,{50,20})</span>=SUMPRODUCT((A8:A13>20)*(A8:A13<=50))=COUNTIFS(A8:A13,">20",A8:A13,"<=50")=SUM((ABS(A8:A13-35.1)<15)*1)2=LARGE((FREQUENCY(A18:A26,A18:A26)>0)*A18:A27,3)=MAX(1*SUBSTITUTE(1*SUBSTITUTE(A18:A26,MAX(A18:A26),0),MAX(1*SUBSTITUTE(A18:A26,MAX(A18:A26),0)),0))3=SUM(--(FREQUENCY(IF(ISERROR(--A30:C35),CODE(A30:C35)%,A30:C35),IF(ISERROR(--A30:C35),CODE(A30:C35)%,A30:C35))=1))4=REPT("不",1-FREQUENCY(B40,{16,12}))&"合格" 本帖最后由 1032446692 于 2015-7-18 12:00 编辑
B08
1。法1：=INDEX(FREQUENCY(A8:A13,{50,20}),1)法2：=COUNTIFS(A8:A13,">20",A8:A13,"<=50")法3：=SUM((A8:A13>20)*(A8:A13<=50))法4：=SUMPRODUCT(N(A8:A13>20),N(A8:A13<=50))法5：=COUNTIF(A8:A13,">20")-COUNTIF(A8:A13,">50")2。法1：=LARGE((FREQUENCY(A18:A26,A18:A26)>0)*A18:A27,3)3。法1：=SUM(1/COUNTIF(A30:C35,A30:C35))4。法1：=IF(INDEX(FREQUENCY(B40,{16,12}),1),"合格","不合格")法2：=RIGHT("不合格",3-INDEX(FREQUENCY(B40/4,{4,3}),1)) B05
1=SUM(FREQUENCY(A8:A13,C8:C9)*{0;1;0})=INDEX(FREQUENCY(A8:A13,C8:C9),2,1)2=LARGE(IF(FREQUENCY(A18:A26,A18:A26),A18:A26,),3)3 考虑大小写区别=COUNT(0/FREQUENCY(IF(A30:C35>9^9,CODE(A30:C35)+10^3,A30:C35),IF(A30:C35>9^9,CODE(A30:C35)+10^3,A30:C35)))不考虑大小写区别=SUM(--(FREQUENCY(IF(A30:C35>9^9,CODE(LOWER(A30:C35))+10^3,A30:C35),IF(A30:C35>9^9,CODE(LOWER(A30:C35))+10^3,A30:C35))>0))4=IF(SUM(FREQUENCY(B40,{12,16})*{0;1;1}),"合格","不合格")=IF(INDEX(FREQUENCY(B40,{12,16}),1,1),"不合格","合格")
B10 : 胖子李
第二讲作业
第一题：
法1：=FREQUENCY(A8:A13,{50,20})法2：=INDEX(FREQUENCY(A8:A13,{20,50}),2)法3：=SUM(COUNTIF(A8:A13,{"<=50","<=20"})*{1,-1})第二题：=LARGE(IF(FREQUENCY(A18:A26,A18:A26)>0,1)*A18:A27,3)第三题：=SUM(IF(FREQUENCY(A30:C35,A30:C35)>0,1))第四题：=IF(FREQUENCY(B40,{16,12}),"合格","不合格")回答完毕，请老师批示！
页:
[1]
2