標示最高與最低 (12585)

C2=TEXT(SUM((PERCENTILE(B:B,{1,0})=B2)*{1,2})-1,"最低;;最高")

另解=IF(MAX(B:B)=B2,"最高",IF(MIN(B:B)=B2,"最低",""))