[开_156]统计提取出现频次最高的类[开帖待评]

delete_007

预设答案：
103字符：

1. =REPLACE(A2&B2&C2,ABS(SUM((MATCH(A2:C2,{0,"a","吖"})=MODE(MATCH(A2:C2,{0,"a","吖"}),4,4))*{5,2,1})-4),1,)

复制代码

91字符：

1. =REPLACE(A2&B2&C2,ABS(SUM((LENB(TEXT(A2:C2,))=MODE(LENB(TEXT(A2:C2,)),3,3))*{5,2,1})-4),1,)

复制代码

86字符：

1. =REPLACE(A2&B2&C2,MIN(IFNA(IF(MODE(LENB(T(+A2:C2)))=LENB(T(+A2:C2)),4,{1,2,3}),4)),1,)

复制代码

85字符：

1. =REPLACE(A2&B2&C2,ABS(SUM((LENB(T(+A2:C2))=MODE(LENB(T(+A2:C2)),3,3))*{5,2,1})-4),1,)

复制代码

624134745

=CONCAT(LET(a,A2:C2,FILTER(a,CHOOSE(IFNA(MODE(MATCH(a,{0,"A","吖"})),4),a<10,(a>9)*(a<="z"),a>="吖",a>0))))修改一下，强行到105个字符了~

1. =CONCAT(LET(a,A2:C2,IF(CHOOSE(IFNA(MODE(MATCH(a,{0,"A","吖"})),4),a<10,(a>9)*(a<="z"),a>="吖",a>0),a,"")))

复制代码

减少1个字符 104.

象山海鲜

1. =CONCAT(REPT(A2:C2,IFNA(MODE(LENB(TEXT(A2:C2,)))=LENB(TEXT(A2:C2,)),1)))

复制代码

限制了版本.......
凑一个先

1. =REPLACE(A2&B2&C2,ABS(SUM((MEDIAN(LENB(TEXT(A2:C2,)))<>LENB(TEXT(A2:C2,)))*{5,6,7})-4),1,)

复制代码

1. =REPLACE(A2&B2&C2,ABS(SUM((MEDIAN(LENB(T(+A2:C2)))<>LENB(T(+A2:C2)))*{5,6,7})-4),1,)

复制代码

误导帝

1. =REPLACE(A2&B2&C2,SUM((MODE(LEN(CODE(A2:C2)+35),0,0)=LEN(CODE(A2:C2)+35))*{8,7,6}/4,-2)^2,1,)

复制代码

补充内容 (2021-7-10 09:27):
=REPLACE(A2&B2&C2,SUM((MODE(LENB(T(+A2:C2)),9,9)=LENB(T(+A2:C2)))*{8,7,6}/4,-2)^2,1,)

补充内容 (2021-7-10 21:32):
83：
=REPLACE(A2&B2&C2,MATCH(,-IF({1,1,1,0},MODE(LENB(T(+A2:C2)))=LENB(T(+A2:C2))),),1,)
偷鸡81：
=REPLACE(A2&B2&C2,MATCH(,-IF(A2:D2>0,MODE(LENB(T(+A2:C2)))=LENB(T(+A2:C2))),),1,)


补充内容 (2021-7-12 13:59):
82：
=REPLACE(A2&B2&C2,MID(4134234320114,ABS(SUM((LENB(T(+A2:C2))-1)*{1,4,7}))+1,1),1,)

补充内容 (2021-7-12 17:08):
77，不讲武德了：
=REPLACE(A2&B2&C2,MID(1/1913&9341,ABS(SUM(LENB(T(+A2:C2))*{-9,1,8}))+6,1),1,)

补充内容 (2021-7-12 22:42):
74：
=REPLACE(A2&B2&C2,MID(351/5089,ABS(SUM(LENB(T(+A2:C2))*{-5,1,4}))+7,1),1,)

补充内容 (2021-7-13 09:20):
73：
=REPLACE(A2&B2&C2,MID(8/46739,ABS(SUM(LENB(T(+A2:C2))*{1,-5,4}))+7,1),1,)

补充内容 (2021-7-13 10:09):
72，就这样吧，不改了：

1. =REPLACE(A2&B2&C2,MID(2/7739,ABS(SUM(LENB(T(+A2:C2))*{3,-5,2}))+8,1),1,)

复制代码

梅州

90字符

1. =REPLACE(A2&B2&C2,ABS(SUM((LENB(TEXT(A2:C2,))<>MEDIAN(LENB(TEXT(A2:C2,))))*{5,6,7})-4),1,)

复制代码

丢丢表格

1. =REPLACE(A2&B2&C2,ABS(SUM((SMALL(LENB(T(+A2:C2)),2)<>LENB(T(+A2:C2)))*{7,8,9})-6),1,)

复制代码

（85字）

（这个 SMALL  应该用 MEDIAN 中值是最合理的方法）

满坛皆为吾师

F2数组三键下拉

1. =REPLACE(A2&B2&C2,LOOKUP(9,IF({6,0},6,MATCH(6>9,LENB(TEXT(A2:C2,))=MODE(LENB(TEXT(A2:C2,))),))),1,)

复制代码

江山社稷

=REPLACE(A2&B2&C2,IFERROR(MATCH(1=0,MODE(MATCH(A2:C2,{0,"a","吖"}))=MATCH(A2:C2,{0,"a","吖"}),),4),1,)

=REPLACE(A2&B2&C2,IFNA(MATCH(1=0,MODE(MATCH(A2:C2,{0,"a","吖"}))=MATCH(A2:C2,{0,"a","吖"}),),4),1,)
=REPLACE(A2&B2&C2,IFNA(MATCH(1=0,MODE(LENB(TEXT(A2:C2,)))=LENB(TEXT(A2:C2,)),),4),1,)

ifna如果不让用
=REPLACE(A2&B2&C2,RIGHT(SUM((FREQUENCY(LENB(TEXT(A2:C2,)),LENB(TEXT(A2:C2,)))=1)*{1;2;3;4},9))+1,1,)

=REPLACE(A2&B2&C2,RIGHT(SUM(IF(MODE(LENB(TEXT(A2:C2,)),4,4)=LENB(TEXT(A2:C2,)),5,{1,2,3}))),1,)

补充内容 (2021-7-22 11:10):
补充

补充内容 (2021-7-22 11:10):

1. =REPLACE(A2&B2&C2,RIGHT(SUM(IF(LENB(TEXT(A2:C2,))=LENB(T(OFFSET(A2,,{1,2,0}))),{3,1,2},5))),1,)

复制代码

Sanday2000

先占个楼124字符
=REPLACE(A2&B2&C2,MATCH(1,FREQUENCY(0,-(MODE(LEN(CODE(A2:C2)+35),1,1)=LEN(CODE(A2:C2)+35))),),10<>SUM(LEN(CODE(A2:C2)+35)),)
数组公式

补充内容 (2021-7-19 20:58):
105字符勉强及格：

1. =REPLACE(A2&B2&C2,MATCH(1,FREQUENCY(LEN(CODE(A2:C2)+35),LEN(CODE(A2:C2)+35))),SUM(N(A2:C2<={"z";9}))<>3,)

复制代码

广东不落雨

1. =IF(OR(SUM(LOOKUP(CODE(A2:C2),{0,0;58,1;123,2}))={0,3,6}),A2&B2&C2,IF(OR(SUM(LOOKUP(CODE(A2:B2),{0,0;58,1;123,3}))={0,2,6}),A2&B2,IF(OR(SUM(LOOKUP(CODE(B2:C2),{0,0;58,1;123,3}))={0,2,6}),B2&C2,A2&C2)))

复制代码