仅落恩 发表于 2015-7-20 17:59

B12：仅落恩
1.1=INDEX(FREQUENCY(A8:A13,C8:C9),2)
1.2=FREQUENCY(A8:A13,{50;20})
2.1=LARGE((MATCH(A18:A26,A18:A26,)=ROW(1:9))*A18:A26,3)三键
2.2=LARGE(IF(FREQUENCY(A18:A26,A18:A26),A18:A26),3)
3.=SUM(1/COUNTIF(A30:C35,A30:C35)) 三键
4.1=IF(FREQUENCY(B40,{16;12}),"合格","不合格")
4.2=FREQUENCY(B40,{16;12}) 自定义单元格格式为："合""格";;"不""合""格"

车仁静 发表于 2015-7-20 20:58

1。=INDEX(FREQUENCY(A8:A13,C8:C9),2)2。=LARGE(IF(FREQUENCY(A18:A26,A18:A26)>0,A18:A26,0),3)3。=COUNT(1/FREQUENCY(IF(ISNUMBER(A30:C35),A30:C35,CODE(A30:C35)%),IF(ISNUMBER(A30:C35),A30:C35,CODE(A30:C35)%)))4。=IF(FREQUENCY(B40,{12,16}),"不合格","合格")

zac0226 发表于 2015-7-21 15:53

B09:zac0226
1=SUMPRODUCT((A8:A13>20)*(A8:A13<=50))=FREQUENCY(A8:A13,{50,20})=SUM(COUNTIF(A8:A13,{"<=50","<=20"})*{1,-1})2=LARGE(IF(FREQUENCY(A18:A26,A18:A26),A18:A26),3)3=SUM(1/COUNTIF(A30:C35,A30:C35))4=IF(($B$40:$B$44>12)*($B$40:$B$44<=16),"合格","不合格")=IF(FREQUENCY(B40,{16;12.9}),"合格","不合格")
页: 1 [2]
查看完整版本: 【函高201501】第二讲B组作业上交贴