求组函数

leepoison

如果是A1=V-1,N-1,K-2,J-2,N-3,J-3,V-4,K-4,V-1,S-4,I-4,U-3,K-3,I-4,R-1,G-2,R-3,R-2,V-3,R-4

用TEXTSPLIT 分开没法用COUNTIF，要怎么弄

jivy1212

1. =COUNTIF($A$2:A2,"*"&RIGHT(A2))

复制代码

leepoison

jivy1212 发表于 2024-11-5 15:04

=MAP(A2:A21,LAMBDA(x,COUNTIF($A$2:x,"*"&RIGHT(x))))

感谢

hugeinfo

=SCAN("",A2:A21,LAMBDA(x,y, COUNTIF(A2:y,"*"&RIGHT(y))))
或者
=SCAN("",A2:A21,LAMBDA(x,y, COUNTIF(A2:y,"*"&TEXTAFTER(y,"-"))))

sqrall900

=MMULT((TRANSPOSE(RIGHT(A2:A21))=RIGHT(A2:A21))*(ROW(2:21)>=COLUMN(B:U)),ROW(1:20)^0)

jivy1212

leepoison 发表于 2024-11-6 11:08
=MAP(A2:A21,LAMBDA(x,COUNTIF($A$2:x,"*"&RIGHT(x))))

感谢

1. =COUNTIF(OFFSET(A2,,,ROW(1:20)),"*"&RIGHT(A2:A21))

复制代码

内存数组啊，没看清，老套路

shaowu459

=MAP(A2:A21,LAMBDA(x,SUM(N(RIGHT(A2:x)=RIGHT(x)))))

leepoison

jivy1212 发表于 2024-11-5 15:04

如果是A1=V-1,N-1,K-2,J-2,N-3,J-3,V-4,K-4,V-1,S-4,I-4,U-3,K-3,I-4,R-1,G-2,R-3,R-2,V-3,R-4

用TEXTSPLIT 分开没法用COUNTIF，要怎么弄

leepoison

shaowu459 发表于 2024-11-5 15:32
=MAP(A2:A21,LAMBDA(x,SUM(N(RIGHT(A2:x)=RIGHT(x)))))

如果是A1=V-1,N-1,K-2,J-2,N-3,J-3,V-4,K-4,V-1,S-4,I-4,U-3,K-3,I-4,R-1,G-2,R-3,R-2,V-3,R-4

用TEXTSPLIT 分开，要怎么弄

一杯绿茶来了

=LET(s,A2:A21,MAP(s,LAMBDA(x,SUM(N(RIGHT(TAKE(s,ROW(x)-1))=RIGHT(x))))))