降序排列 依出現次數 (11837)

D2{=IFERROR(INDEX(A:A,RIGHT(LARGE(IF(COUNTIF(D$1:D1,A$2:A$16)=0,COUNTIF(A:A,A$2:A$16)/1%+ROW($2:$16)),1),2)),"")

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