排序 出現次數 (10104)

C2{=IFERROR(MODE(IF(COUNTIF(C$1:C1,A$2:A$10)=0,A$2:A$10),IF(COUNTIF(C$1:C1,A$2:A$10)=0,A$2:A$10)),"")

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