用字符统计函数普通公式:
=SUMPRODUCT(N(FIND(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),A2)=ROW(INDIRECT("1:"&LEN(A2)))))
数组公式:
=SUM(IF(FIND(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),A2)=ROW(INDIRECT("1:"&LEN(A2))),1,0))
公式以CTRL+SHIFT+回车结束.
参考资料:http://zhidao.baidu.com/question/69421384.html