(先) H2{=MAX(FREQUENCY(ROW($4:27),IF(B$1:B26&C$1:C26<>E4&F4,ROW($1:26))))-1
起止行號 G2{=SUBSTITUTE(IMSUM((MATCH(H4+1,FREQUENCY(ROW($4:27),IF(B$1:B26&C$1:C26<>E4&F4,ROW($1:26),)),)-H4^{1,0})*{1,-1}&{"","i"}),"i",)
另解 (起止日期)G2{=TEXT(SUM(N(OFFSET(A$1,MATCH(H4+1,FREQUENCY(ROW($4:27),IF(B$1:B26&C$1:C26<>E4&F4,ROW($1:26),)),)-H4^{1,0}-1,))*{100,1}),"00-00")
留言
張貼留言