排序 顯字母與次數 (9437)


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


留言