排序 出現次數 (10962)

L2:L12{=IFERROR(INDIRECT(TEXT(RIGHT(LARGE(IF(COUNTIF(L$1:L1,A$2:J$11)=0,COUNTIF(A:J,A$2:J$11)/1%%+ROW($2:$11)/1%+COLUMN(A:J)),1),4),"!R0C00"),),"")

M2:M12=IF(L2="","",COUNTIF(A:J,L2))