本帖最后由 zhh823543 于 2012-5-25 12:31 编辑
A02 zhh823543交作业
第1题:- =INDEX(FREQUENCY(A8:A13,C8:C9),2)
复制代码 或- =FREQUENCY(A8:A13,C8+C9-C8:C9)
复制代码 第2题:
- =INDEX(A18:A26,SUM((MMULT(N(IF(FREQUENCY(A18:A26,A18:A26),A18:A26)-TRANSPOSE(IF(FREQUENCY(A18:A26,A18:A26),A18:A26))<=0),ROW(A18:A27)^0)=3)*(ROW(A18:A27)-17)))
复制代码 或
- =INDEX(A18:A26,MATCH(3,MMULT(N(IF(FREQUENCY(A18:A26,A18:A26),A18:A26)-TRANSPOSE(IF(FREQUENCY(A18:A26,A18:A26),A18:A26))<=0),ROW(A18:A27)^0),))
复制代码
第3题:
- =COUNT(1/FREQUENCY(COUNTIF(A30:C35,">="&A30:C35)+ISTEXT(A30:C35)*ROWS(A30:C35)*COLUMNS(A30:C35),COUNTIF(A30:C35,">="&A30:C35)+ISTEXT(A30:C35)*ROWS(A30:C35)*COLUMNS(A30:C35)))
复制代码 |