【函高201501】第二讲C组作业上交贴

ddmyykdzh

1、

1. INDEX(FREQUENCY(A8:A13,C8:C9),2)

复制代码

1. FREQUENCY(A8:A13,{50,20})

复制代码

2、

1. LARGE(IF(FREQUENCY(A18:A26,A18:A26),A18:A26),3)

复制代码

3、

1. SUM(N(IFERROR(FREQUENCY(IF(ISNUMBER(A30:C35),A30:C35,1000),IF(ISNUMBER(A30:C35),A30:C35,1000))>0,"")))

复制代码

4、

1. IF(INDEX(FREQUENCY(B40,{12,16}),2)=1,"合格","不合格")

复制代码

神隐汀渚

1. =FREQUENCY(A8:A13,C8:C9)
   
2. =LARGE(IF(FREQUENCY(A18:A26,A18:A26),A18:A26),3)
   
3. =COUNT(1/FREQUENCY(IF(ISNUMBER(A30:C35),A30:C35,MAX(A30:C35)+1),IF(ISNUMBER(A30:C35),A30:C35,MAX(A30:C35)+1)))
   
4. =CHOOSE(2-FREQUENCY(IF(($B$40:$B$44>12)*($B$40:$B$44<=16),ROW($B$40:$B$44)),ROW($B$40:$B$44)),"","不")&"合格"

复制代码

E界白菜

C07:E界白菜
第一题

1. =FREQUENCY(A8:A13,N(OFFSET(C7,3-ROW(1:2),)))

复制代码

第二题

1. =LARGE(IF(FREQUENCY(A18:A26,A18:A26),A18:A26),3)

复制代码

第三题

1. =SUM(N(FREQUENCY(CODE(A30:C35),CODE(A30:C35))>0))

复制代码

第四题

1. =IF(FREQUENCY(B40,{16,12}),"","不")&"合格"

复制代码

木偶fenzi

1. =LOOKUP(2,ROW(1:3),FREQUENCY(A8:A13,C8:C9))

复制代码

1. =INDEX(FREQUENCY(A8:A13,C8:C9),2)

复制代码

1. =FREQUENCY(A8:A13,{50;20})

复制代码

第二题

1. =LARGE((FREQUENCY(A18:A26,A18:A25)>0)*A18:A26,3)

复制代码

第三题

1. =SUM(N(FREQUENCY(--TEXT(A30:C35,"0;0;0;!1!0!0"),A30:C35)>0))

复制代码

1. =SUM(1/COUNTIF(A30:C35,A30:C35))

复制代码

第四题

1. =TEXT(INDEX(FREQUENCY(B40,{12;16}),2),"合格;;不合格")

复制代码

1. =IF(INDEX(FREQUENCY(B40,{12;16}),2),,"不")&"合格"

复制代码

1. =IF(FREQUENCY(B40,{16;12}),"合格","不合格")

复制代码

1. =TEXT(FREQUENCY(B40,{16;12}),"合格;;不合格")

复制代码

xmergea

第一题：
=FREQUENCY(A8:A13,{50,20})
=LOOKUP(2,{1,2,3},FREQUENCY(A8:A13,C8:C9))
第二题：
=INDEX(A18:A26,LARGE(IF(FREQUENCY(A18:A26,A18:A26),ROW(A1:A9),0),3))
=LARGE(IF(FREQUENCY(A18:A26,A18:A26),A18:A26),3)
第三题：
=SUM(1/COUNTIF(A30:C35,A30:C35))
=SUM(IF(FREQUENCY(IF(ISERROR(-A30:C35),99,--A30:C35),IF(ISERROR(-A30:C35),99,--A30:C35))>0,1))
=COUNT(1/FREQUENCY(IF(ISERROR(-A30:C35),99,--A30:C35),IF(ISERROR(-A30:C35),99,--A30:C35)))
第四题：
=IF(FREQUENCY(B40,{16,12}),"合格","不合格")