排序 姓名出現次数 (10103)

G2{=IFERROR(INDIRECT(TEXT(RIGHT(LARGE(IF(COUNTIF(G$1:G1,A$2:F$9)=0,COUNTIF(A:F,A$2:F$9)/1%%+ROW($2:$9)/1%+COLUMN(A:F)),1),4),"!R0C00"),),"")

H2=COUNTIF(A:F,G2)