F2:F4{=TEXT(MAX(FREQUENCY(ROW($2:$13),IF(ISNUMBER(MATCH(B$2:B$13+1,B$2:B$13*(A$2:A$13=D2),))*(A$2:A$13=D2),"",ROW($2:$13)))),"[<2]!0")
另解{=TEXT(MAX(FREQUENCY(IF(ISNUMBER(IF(A$2:A$13=D2,0/MATCH(B$2:B$13+1,(A$2:A$13=D2)*B$2:B$13,))),ROW($2:$13)),IF(ISERROR(IF(A$2:A$13=D2,0/MATCH(B$2:B$13+1,(A$2:A$13=D2)*B$2:B$13,))),ROW($2:$13)))),"0;;-1")+1
另解{=TEXT(MAX(FREQUENCY(ROW($1:$12),IF(IF(A$2:A$13=D2,$B$2:$B$13)+1<>IF(A$3:A$14=D2,$B$3:$B$14),ROW($1:$12)))),"[<2]!0")
留言
張貼留言