1. =SUM(SUBTOTAL(4,OFFSET(D192,{0,1,2},1,,3)))
2.方法一 =COUNTIFS($D$198:$D$207,D198,$I$198:$I$207,">"&I198)+1
方法二 =RANK($I198,OFFSET($I$197,MATCH($D198,$D$198:$D$207,0),,COUNTIF($D$198:$D$207,$D198)))
3.方法一 =INDEX(I$211:I$216,MATCH("*"&D$218&"*",D$211:D$216,))
方法二 =LOOKUP(9,FIND(D218&"汽",D211:D216),I211:I216)
4.=VLOOKUP(D227&E227&F227,CHOOSE({1,2},G221:G225&E221:E225&F221:F225,D221:D225),2,)
5.方法一 =MID(D236,MIN(FIND({0,1,2,3,4,5,6,7,8,9},D236&"0123456789")),LEN(D236))
方法二 =MID(D236,MATCH(TRUE,ISNUMBER(1*MID(D236,ROW($1:$9),1)),0),COUNT(1*MID(D236,ROW($1:$9),1)))
方法三 =-LOOKUP(,-MID(D236,MATCH(,0*MID(D236,ROW($1:$16),1),),ROW($1:$16)))
6.方法一 =MID(D242,MATCH(TRUE,ISNUMBER(1*MID(D242,ROW($1:$9),1)),0),COUNT(1*MID(D242,ROW($1:$9),1)))
方法二 =-LOOKUP(,-MID(D242,MATCH(,0*MID(D242,ROW($1:$16),1),),ROW($1:$16)))
|