找出 高 低 中間 (10974)

C2{=IFERROR(LOOKUP(1,0/(B2=PERCENTILE(B$2:B$10,{1,0.5,0})),{"最高","中間","最低"}),"")

D2{=IF(MAX(B$2:B$10)=B2,"最高",IF(MIN(B$2:B$10)=B2,"最低",IF(MEDIAN(B$2:B$10)=B2,"中間","")))