C10{=SUM(OFFSET(C$1,MIN(IF(TEXT(A$1:A9,"EM")=TEXT(LOOKUP(9^9,A$1:A9),"EM"),ROW($1:9)))-1,,SUM(PERCENTILE(IF(TEXT(A$1:A9,"EM")=TEXT(LOOKUP(9^9,A$1:A9),"EM"),ROW($1:9)),{1,0})*{1,-1})+1))
另解{=SUM(OFFSET(C$1,MIN(IF(TEXT(A$1:A9,"EM")=TEXT(LOOKUP(9^9,A$1:A9),"EM"),ROW($1:9)))-1,,ROW()-MIN(IF(TEXT(A$1:A9,"EM")=TEXT(LOOKUP(9^9,A$1:A9),"EM"),ROW($1:9)))))
C10複製到黃色填滿
留言
張貼留言