第一题 = LARGE(B3:I3,2)
第二题 =LARGE(B3:I3,ROW(A1))
第三题 =LARGE(B3:I3,2*ROW(A1)-1)
第四题 =MAX(B$3:B$6)+MAX(F$3:F$6)+MAX(I$3:I$6)
第五题 {=INDEX($B$30:$B$39,SMALL(IF($A$30:$A$39=LARGE($A$30:$A$39,3),ROW($1:$10),4^8),ROW(A3)))+INDEX($B$30:$B$39,SMALL(IF($A$30:$A$39=LARGE($A$30:$A$39,8),ROW($1:$10),4^8),ROW(A2))) }三键合一
第六题 方法一 {=LARGE(IF(TEXT(A43:A52,"yyyym")="20134",B43:B52,""),1)}
{=SMALL(IF(TEXT(A43:A52,"yyyym")="20134",B43:B52,""),1)}
方法二{=MAX(IF((A43:A52>DATE(2013,4,0))*(A43:A52<DATE(2013,5,0)),B43:B52,""))}
{=MIN(IF((A43:A52>DATE(2013,4,0))*(A43:A52<DATE(2013,5,0)),B43:B52,""))}
第七题 { =INDEX($A$56:$A$68,SMALL(IF(LEFT($A$56:$A$67)="电",ROW($1:$12),13),ROW(A1)))&""} |