EXCEL中求一组数列中出现频率最少的数字怎么求得?

Question

EXCEL中求一组数据中出现频率最少的数字怎么求得?
比如:2135838354112543509,怎么求的以上一组数据出现频率最少的是那一个?或那一些??
这些数字不是在一个单元格里面,而是每个单元格只有一个数字,A1=2,A2=1,A3=0,A4=8,A5=……

Answer 1

=SMALL(IF(LEN(A$1)-LEN(SUBSTITUTE($A$1,{0,1,2,3,4,5,6,7,8,9},""))=MIN(IF(LEN(A$1)-LEN(SUBSTITUTE(A$1,{0,1,2,3,4,5,6,7,8,9},""))>0,LEN(A$1)-LEN(SUBSTITUTE(A$1,{0,1,2,3,4,5,6,7,8,9},"")))),{0,1,2,3,4,5,6,7,8,9}),ROW(1:1))
公式以CTRL+SHIFT+回车结束.
向下复制公式.

补充回答:
B1=INDEX(A:A,SMALL(IF((COUNTIF($A$1:$A$19,$A$1:$A$19)=MIN(COUNTIF($A$1:$A$19,$A$1:$A$19)))*(MATCH($A$1:$A$19,$A$1:$A$19,)=ROW($1:$19)),ROW($1:$19),65536),ROW(1:1)))&""
数组公式,向下复制.