[已解决]单元格内字母出现最多次数

无止学习

一个单元格有几个不同字母，怎么统计那个字母出现次数最多

最佳答案

月排行榜 / 总排行榜

ssg365

2022-6-5 21:47

=CONCAT(CHAR(64+MODE.MULT(MATCH(MID(B4,ROW(INDIRECT("1:"&LEN(B4))),1),CHAR(ROW($65:$90)),))))

跳转到最佳答案楼层

hugeinfo

一火车     祝顺心！！=IFERROR(INDEX(MID($B4,ROW(INDIRECT("1:"&LEN($B4))),1),SMALL(IF(FREQUENCY(MATCH(MID($B4,ROW(INDIRECT("1:"&LEN($B4))),1),MID($B4,ROW(INDIRECT("1:"&LEN($B4))),1),),MATCH(MID($B4,ROW(INDIRECT("1:"&LEN($B4))),1),MID($B4,ROW(INDIRECT("1:"&LEN($B4))),1),))=          MAX(FREQUENCY(MATCH(MID($B4,ROW(INDIRECT("1:"&LEN($B4))),1),MID($B4,ROW(INDIRECT("1:"&LEN($B4))),1),),MATCH(MID($B4,ROW(INDIRECT("1:"&LEN($B4))),1),MID($B4,ROW(INDIRECT("1:"&LEN($B4))),1),))),ROW(INDIRECT("1:"&LEN($B4))),9^9),COLUMN(A1))),"")

ssg365

=CONCAT(CHAR(64+MODE.MULT(MATCH(MID(B4,ROW(INDIRECT("1:"&LEN(B4))),1),CHAR(ROW($65:$90)),))))

无止学习

ssg365 发表于 2022-6-5 21:47
=CONCAT(CHAR(64+MODE.MULT(MATCH(MID(B4,ROW(INDIRECT("1:"&LEN(B4))),1),CHAR(ROW($65:$90)),))))

十分感谢，高手

一剑惊心

=CONCAT(CHAR(MODE.MULT(CODE(MID(B4,SEQUENCE(LEN(B4)),1)))))