排序 依出現次數 (13396)

D2{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(MATCH(B$2:B$21,B:B,)=ROW($2:$21),COUNTIF(B:B,B$2:B$20)/1%+ROW($2:$21)),ROW(A1)),2)),"")

E2=IF(D2="","",COUNTIF(B:B,D2))