第五期函高毕业考试A组上交贴

pureshadow

第五期函高毕业考试A组上交贴

上交作业设置了回贴仅楼主可见，所以不必用回复可见贴
上交方式随意，只贴公式或上传附件都可以

今晚8点，考试题会发到Q群共享，请大家注意查收

pureshadow

对得一模一样，那个可以理解……
错得一模一样，那个……

zjcat35

A09:zjcat35
1、

1. =MAX(FREQUENCY(IF(B$10:B$19=--MID(310,ROW(A1),1),ROW(1:10)),IF(B$10:B$19-MID(310,ROW(A1),1),ROW(1:10))))

复制代码

2、

1. =MAX(FREQUENCY(ROW(1:10),IF(A29:G38=50,ROW(1:10))))-1

复制代码

3、

1. =SUM(MOD(LARGE((A46:A58=TRANSPOSE(A46:A58))*B46:B58+(14-COLUMN(A:M))*10^5,ROW(1:13)*13-12),10^5)/COUNTIF(A:A,A46:A58))

复制代码

4、

1. =SUM(B65:B67*OFFSET($H65:$H67,,MATCH(B64,$I64:$M64,)))

复制代码

　右拉
5、

1. =IF(MAX(FREQUENCY(A75:B75,{2,58}))-1,"次品","合格品")

复制代码

zhh823543

A02.zhh823543
1.

1. =MAX(FREQUENCY(IF(B10:B19=VLOOKUP(A21,{"连胜",3;"连平",1;"连负",0},2,),ROW(B$10:B$19)),IF(B10:B19<>VLOOKUP(A21,{"连胜",3;"连平",1;"连负",0},2,),ROW(B$10:B$19))))

复制代码

2.

1. =MAX(FREQUENCY(IF(MMULT(N(A29:G38=50),TRANSPOSE(COLUMN(A29:G29)))=0,ROW(A29:A38)),IF(MMULT(N(A29:G38=50),TRANSPOSE(COLUMN(A29:G29)))<>0,ROW(A29:A38))))

复制代码

3.

1. =SUM(IF(MATCH(A46:A58,A46:A58,0)=ROW(A1:A13),DMAX(OFFSET(A45,ROW(A1:A13)-1,,15-ROW(A1:A13),2),2,OFFSET(A45,ROW(A1:A13)-1,,2))))

复制代码

4.

1. =MMULT({1,1,1},SUMIF(B64:F64,B64:F64,OFFSET(B64,ROW(1:3),,,5))*SUMIF(I64:M64,B64:F64,OFFSET(I64,ROW(1:3),,,5)))

复制代码

5.

1. =IF(FREQUENCY(A75,{99,2.999999})*FREQUENCY(B75,58.999999),"次品","合格品")

复制代码

5blessyou

交作业了，第一题有疑问，不知道连续最大场次还是所有连续场次

魔魔

考试好紧张{:251:}

wjc2090742

A03wjc2090742
1数组公式下拉

1. =SUM(N(B$11:B$19+B$10:B$18=ROW(A1)*(ROW(A1)-7)+12))+1

复制代码

2

1. =MAX(--TEXT(MMULT(SMALL(IF(A29:G38=50,ROW(1:10),99),ROW(1:69)+{0,1}),{-1;1}),"[>9]1"))-1

复制代码

1. =SUM(MATCH({50,51},SMALL(A29:G38+ROW(1:10)%,ROW(1:70)))*{-1,1})-1

复制代码

3

1. =MOD(SUM(LARGE((--RIGHT(A46:A58)={1,2,3,4,5})*B46:B58+{1,2,3,4,5}*10^8,{1,14,27,40,53})),10^8)

复制代码

4

1. =MMULT({1,1,1},N(OFFSET(H64,{1;2;3},MATCH(B64:F64,I64:M64,)))*B65:F67)

复制代码

5

1. =IF((A75>2)*(B75<59),"次品","合格品")

复制代码

1. =IF(FREQUENCY(B75,59)*(A75>2),"次品","合格品")

复制代码

cloud-sj

技术有限，望小妖老师批阅时手下留情

liuho1

1.{=SUM(IF((IF(B$11:B19=3,ROW(B$11:B19))-IF(B$10:B18=3,ROW(B$10:B18)))=1,1)*1)+1}

序列想不出啊！
2.{=MAX(SMALL(IF(COUNTIF(OFFSET(A28,ROW(1:10),,1,7),50),ROW(1:10)),ROW(2:6))-SMALL(IF(COUNTIF(OFFSET(A28,ROW(1:10),,1,7),50),ROW(1:10)),ROW(1:5))-1)}
3{=SUM(IF(MATCH(A46:A58,A46:A58,)=ROW(1:13),DMAX(INDIRECT("A"&ROW(45:57)&":B58"),2,INDIRECT("A"&ROW(45:57)&":A"&ROW(46:58)))))}
4.{=MMULT(COLUMN(A:C)^0,N(OFFSET(A64,ROW(1:3),COLUMN(A:E)))*N(OFFSET(H64,ROW(1:3),MATCH(B64:F64,I64:M64,))))}
5.=IF(INDEX(FREQUENCY(A75,3),2)*INDEX(FREQUENCY(B75,59),1),"次品","合格品")

qingfeng_qf

1.

1. =MAX(FREQUENCY(IF(B10:B19=3,ROW(B10:B19)),IF(B10:B19<>3,ROW(B10:B19))))
   
2. =MAX(FREQUENCY(IF(B10:B19=1,ROW(B10:B19)),IF(B10:B19<>1,ROW(B10:B19))))
   
3. =MAX(FREQUENCY(IF(B10:B19=0,ROW(B10:B19)),IF(B10:B19<>0,ROW(B10:B19))))

复制代码

2.

1. =MAX(IF(LARGE(I29:O38,ROW(1:9)+10*(COLUMN(A:G)-1))-LARGE(I29:O38,ROW(2:10)+10*(COLUMN(A:G)-1))<10,LARGE(I29:O38,ROW(1:9)+10*(COLUMN(A:G)-1))-LARGE(I29:O38,ROW(2:10)+10*(COLUMN(A:G)-1)),0))-1

复制代码

3.

1. =SUM(IF(MATCH(A46:A58,A46:A58,)=ROW(1:13),DMAX(INDIRECT("a"&ROW(45:57)&":b58"),2,INDIRECT("a"&ROW(45:57)&":a"&ROW(46:58)))))

复制代码

4.

1. =MMULT(COLUMN(A:C)^0,N(OFFSET(A64,ROW(1:3),COLUMN(A:E)))*N(OFFSET(H64,ROW(1:3),MATCH(B64:F64,I64:M64,))))

复制代码

5.=IF(INDEX(FREQUENCY(A75,3),2)*INDEX(FREQUENCY(B75,59),1),"次品","合格品")