1.
2。- =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.- =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,))))
复制代码 |