( 1) E2{=IFERROR(INDEX(A:A,RIGHT(SMALL(IF(MATCH(A$2:A$16&C$2:C$16,$A$2:A$16&C$2:C$16,)=ROW($1:$15),MATCH(A$2:A$16,A:A,)/1%+ROW($2:$16)),ROW(A1)),2)),"")
( 2 ) H2{=IFERROR(INDEX(C:C,RIGHT(SMALL(IF(MATCH(A$2:A$16&C$2:C$16,$A$2:A$16&C$2:C$16,)=ROW($1:$15),MATCH(A$2:A$16,A:A,)/1%+ROW($2:$16)),ROW(A1)),2)),"")
(LAST) F2:G16{=IF($E2="","",INDEX(PERCENTILE(IF($A$2:$A$16&$C$2:$C$16=$E2&$H2,$B$2:$B$16),{0,1}),COLUMN(A1)))
留言
張貼留言