排序 依出現次數 (10860)

I3{=MID(SUM(IFERROR(RIGHT(LARGE(IF(MATCH(A3:H3,A3:H3,)=COLUMN(A:H),COUNTIF(A3:H3,A3:H3)/1%+A3:H3-COLUMN(A:H)*10),ROW($1:$8)))*10^-ROW($1:$8),)),3,9)

J3{=MID(SUM(RIGHT(LARGE(IFERROR(TEXT(FREQUENCY(A3:H3,A3:H3),"0;;")/1%-ROW($1:$8)*10+TRANSPOSE(A3:H3),),ROW($1:$8)))*10^-ROW($1:$8)),3,9)