出現起止 找最大 最小值 (14031)

H2:I3{=INDEX(PERCENTILE(IF(($B$2:$B$16=$E2)*(COUNTIF(OFFSET($B$2,,,ROW($1:$15)),$B$2:$B$16)>=$F2)*(COUNTIF(OFFSET($B$2,,,ROW($1:$15)),$B$2:$B$16)<=$G2),$C$2:$C$16),{1,0}),COLUMN(A1))



留言