【函高201501】第二讲A组作业上交贴
作业贴先发出来回贴的都上传个附件啦,那么多蚯蚓文直接在网页上看难度太大~~
出于好奇误回贴者负BB奖励{:331:}
17楼有说明 先交为妙^:D
赶着出差,第三题没时间烧脑了,下周补上。 {:021:} 妖,请批阅 第1题
=FREQUENCY(A8:A13,LARGE(C8:C9,ROW(1:2)))
第2题
=LARGE(IF(FREQUENCY(A18:A26,A18:A26),A18:A26),3)
第3题
=COUNT(1/FREQUENCY(A30:C35,A30:C35))+COUNT(0/FREQUENCY(IFERROR(CODE(TEXT(A30:C35,";;;@")),FALSE),IFERROR(CODE(TEXT(A30:C35,";;;@")),FALSE)))
=SUM(1/COUNTIF(A30:C35,A30:C35))
第4题
=IF(FREQUENCY(IF(B40:B44>12,B40:B44+ROW(B40:B44)%),B40:B44+ROW(B40:B44)%),"合格","不合格") 本帖最后由 cg372101 于 2015-7-16 15:20 编辑
A13 : cg372101 作业二:
1.=INDEX(FREQUENCY(A8:A13,C8:C9),2)=FREQUENCY(A8:A13,C8+C9-C8:C9)2.=LARGE(IF(FREQUENCY(A18:A26,A18:A26),A18:A26),3)3.三键=SUM(FREQUENCY(COUNTIF(A30:C35,A30:C35),ROW(1:18))/ROW(1:19))4.下拉=IF(FREQUENCY(B40,{16,12}),"","不")&"合格" 上交作业了,谢谢老师、学委! 谢谢小妖,辛苦了
页:
[1]
2