出現次數大於指定數 (9127)

N2{=IFERROR(INDIRECT(TEXT(MIN(IF((COUNTIF(A:J,A$1:J$10)>L$2)*(COUNTIF(N$1:N1,A$1:J$10)=0),ROW($1:$10)/1%+COLUMN(A:J))),"!R0C00"),),"")

O2=IF(N2="","",COUNTIF(A:J,N2))

格式化 A1:J10=COUNTIF($A:$J,A1)>$L$2