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

cutecpu

1. =CHOOSE(MAX(MID(SUM(10^MATCH(A2:C2,{0,"","吖"})*{3,4,5}),{1,2,3},1)-5,1),A2&B2&C2,A2&B2,A2&C2,B2&C2)

复制代码

祝順心，南無阿彌陀佛！

三秋之叶

来个简明思路，先来个97字符拿个技术分
=CONCAT(IFNA(IF(MODE(MATCH(CODE(A2:C2),8^{1,2,3}))=MATCH(CODE(A2:C2),8^{1,2,3}),A2:C2,""),A2:C2))

用LET优化后，还有75字符

1. =LET(X,A2:C2,Y,MATCH(CODE(X),8^{1,2,3}),CONCAT(IFNA(IF(MODE(Y)=Y,X,""),X)))

复制代码

三秋之叶

1. =CONCAT(IFNA(IF(MODE(MATCH(A2:C2,{0,"A","吖"}))=MATCH(A2:C2,{0,"A","吖"}),A2:C2,""),A2:C2))

复制代码

用LET
=LET(X,A2:C2,Y,MATCH(X,{0,"A","吖"}),CONCAT(IFNA(IF(MODE(Y)=Y,X,""),X)))

三秋之叶

1. =REPLACE(A2&B2&C2,TEXT(SUM((MATCH(A2:C2,{0,"A","吖"})<>MEDIAN(MATCH(A2:C2,{0,"A","吖"})))*{2,3,4})-1,"0;4"),1,)

复制代码

一下子难了好多，109字符，好无语

临沂-枸杞

1. =CONCAT(IF(IFERROR(MODE(MATCH(A2:C2,{0;"a";"吖"}))=MATCH(A2:C2,{0;"a";"吖"}),1),A2:C2,""))

复制代码

sayhi95

1. =LET(x,A2:C2,y,LENB(x)-(x<""),CONCAT(IFNA(IF(MODE(y)=y,x,""),x)))

复制代码

这是一道没有版本限制的友好题目吗，哈哈
这下连IFERROR都不能用了 重在参与

1. =REPLACE(A2&B2&C2,LOOKUP(9,IF({1,0},4,MATCH(1=1,MODE(LENB(A2:C2)-(A2:C2<""))<>LENB(A2:C2)-(A2:C2<""),))),1,)

复制代码

艰难啊

1. =REPLACE(A2&B2&C2,MATCH(,0/IF({1,1,1,0},MODE((A2:C2>"z")+(A2:C2>9))-(A2:C2>"z")-(A2:C2>9),1),),1,)

复制代码

要是能用IFNA就好了

1. =REPLACE(A2&B2&C2,MATCH(,0/IF({1,1,1,0},MODE(LENB(T(+A2:C2)))-LENB(T(+A2:C2)),1),),1,)

复制代码

sucx007

1. =REPLACE(A2&B2&C2,IF(COUNT(MATCH({2,1,0},LENB(A2:C2)-(A2:C2<""),))=2,MATCH(1=1,MODE(LENB(A2:C2)-(A2:C2<""))<>LENB(A2:C2)-(A2:C2<""),),4),1,)

复制代码

=concat(IFNA(IF(MODE(MMULT({1,1},N(A2:C2>{9;"z"})))=MMULT({1,1},N(A2:C2>{9;"z"})),A2:C2,""),A2:C2))

624134745

1. =IFNA(CONCAT(LET(a,CODE(A2:C2),FILTER(A2:C2,CHOOSE(MODE(MATCH(a,{48,65,123})),a<65,(a>=65)*(a<123),a>123)))),CONCAT(A2:C2))

复制代码

重在参与一下，用了365还是123个字符。

zhjlgaojuan

用的365版函数

1. =_xlfn.LET(_xlpm.b,A2:C2,_xlpm.a,-TEXT(CODE(_xlpm.b),"[>500]1;[>64]2;3"),CONCAT(IFNA(IF(_xlpm.a=MODE(_xlpm.a),_xlpm.b,""),_xlpm.b)))

复制代码

魚。。

咦，加了版本限制，重新凑一个，感觉还是不靠谱，等着开贴学习学习。

1. =TRIM(REPLACE(" "&A2&B2&C2,SUM(IF(LENB(TEXT(A2:C2,))=MEDIAN(LENB(TEXT(A2:C2,))),2/5,{2,3,4})),1,))

复制代码