|
【函中201301班】-C10-雨后的风
第一题:第二题:第三题:- =LARGE(B3:H3,ROW(A1)*2-1)
复制代码 第四题:- =SUMPRODUCT(MOD((LARGE(B3:H6+10^COLUMN(B:H),{1,13,25})),100))
复制代码- SUMPRODUCT(MOD(LARGE(B3:H6+MMULT(10^COLUMN(B:D),N(--LEFT(B2:H2)={1;4;7})),{1,5,9}),100))
复制代码 第五题:- =SUM((A30:A39-ROW(1:10)%=LARGE(A30:A39-ROW(1:10)%,{3,9}))*B30:B39)
复制代码- =SUM(IF((A30:A39+(10-ROW(1:10))%=LARGE(A30:A39+(10-ROW(1:10))%,{3,9})),B30:B39,))
复制代码- =SUM(N(OFFSET(B29,99-RIGHT(SMALL(-(A30:A39&99-ROW(1:10)),{3,9}),2),)))
复制代码 第六题:- =MAX((MID(TEXT(A43:A52,"em"),4,2)="34")*B43:B52)
复制代码- =MAX((A43:A52<41395)*(A43:A52>41364)*B43:B52)
复制代码 第七题:- =OFFSET(A$55,SMALL(IFERROR(FIND("电",A$56:A$67)*ROW($1:$12),99),ROW(A1)),)&""
复制代码- =INDIRECT("A"&55+SMALL(IF(FIND("电",A$56:A$67&"电")=1,ROW($1:$12),99),ROW(A1)))&""
复制代码- =INDEX(A:A,55+SMALL(IF(FIND("电",A$56:A$67&"电")=1,ROW($1:$12),99),ROW(A1)),)&""
复制代码 |
评分
-
查看全部评分
|