判斷 保留或删除 (12633)

D2{=CHOOSE(COUNTIF(A:A,A2),"保留","删除",IF(B2=MEDIAN(IF(A$2:A$22=A2,B$2:B$22)),"保留","删除"))

另解{=IF(MEDIAN(IF(A$2:A$22=A2,B$2:B$22))=B2,"保留","删除")

另解{=IF(QUARTILE(IF(A$2:A$22=A2,B$2:B$22),2)=B2,"保留","删除")