同内容显示最小與最大值 (11241)

一式公式 D3:E11{=IF(INDEX(PERCENTILE(IF($B$3:$B$11=$B3,$C$3:$C$11),{0,1}),COLUMN(A1))=$C3,$C3,"")

D3=IF(COUNTIFS(B:B,B3,C:C,"<"&C3),"",C3)

E3=IF(COUNTIFS(B:B,B3,C:C,">"&C3),"",C3)