最高與最低 分別取出 (14030)

F2{=INDEX(PERCENTILE(IF(B$2:B$16=E2,C$2:C$16),{1,0}),MOD(ROW(A2),2)+1)

另解{=ABS(MAX(IF(B$2:B$16=E2,C$2:C$16*-1^(E1=E2))))