本帖最后由 CheryBTL 于 2012-8-1 21:51 编辑
第一题:- =MAX(FREQUENCY(IF(B$10:B$19=LOOKUP(A21,{"连负";"连平";"连胜"},{0,1,3}),A$10:A$19),IF(B$10:B$19<>LOOKUP(A21,{"连负";"连平";"连胜"},{0,1,3}),A$10:A$19)))
- =COUNT(FIND(REPT(2,ROW($1:9)),SUM(2^(B$10:B$19=LOOKUP(A21,{"连负";"连平";"连胜"},{0,1,3}))*10^ROW(1:10))))
复制代码 第二题:- =MAX(--TEXT(FREQUENCY(ROW(1:300),IF(A29:G38=50,ROW(1:10)+COLUMN(A:G)*30)),"[>10]!0;0"))-1
复制代码 第三题:- =SUM(RIGHT(LARGE((A46:A58=TRANSPOSE(A46:A58))+B46:B58%%%+(16-COLUMN(A:M))/1%,ROW(1:13)*13-12),4)/COUNTIF(A46:A58,A46:A58)%)
复制代码 第四题:- =MMULT({1,1,1},B65:F67*N(OFFSET(H64,{1;2;3},MATCH(B64:F64,I64:M64,))))
复制代码 第五题:- =IF(INDEX(FREQUENCY(A75:B75,{2,58}),2)=2,"次品","合格品")
复制代码 |