字元種類 各出現次數 (14676)

N2:N4=INDEX(FREQUENCY(CODE(B$2:K$11),{47,57,64,90,96,122}),ROW(A1)*2)

N5=100-SUM(N2:N4)

B2:K11格式化=(CODE(B2)>47)*(CODE(B2)<58)