问题16 如何实现分组排名

delete_007

1. =RANK.EQ(D3,INDEX(D:D,MATCH("座",B$1:B3,1)):INDEX(D:D,MODE(ROW(3:33)+(B4:C34="")%)))

复制代码

飞天篮球猪

仅供参考...

1. =LET(a,SCAN(0,B3:B18>0,SUM),
   
2.      b,GROUPBY(a,SEQUENCE(ROWS(a)),LAMBDA(x,LET(c,OFFSET(D2,@x,,ROWS(x)),RANK(c,c)))),
   
3.      REDUCE("排名",DROP(b,-1,1),VSTACK))

复制代码

ericxzhou

Python+Pandas:

你是那块小饼干

=MATCH(D3,SORT(FILTER($D$3:$D$18,SCAN(,$B$3:$B$18,LAMBDA(X,Y,LOOKUP("座",$B$3:Y)))=LOOKUP("座",$B$3:B3)),,-1),0)

jivy1212

1. =COUNT((D$3:D$18/(SUBTOTAL(3,OFFSET(B$3,,,ROW($1:$16),))=COUNTA(B$3:B3))>D3)^0)+1

复制代码

下拉

hxj119

1. =LET(a,SCAN(0,B3:B18,LAMBDA(m,n,IF(n<>"",m+1,m))),DROP(REDUCE("",UNIQUE(a),LAMBDA(x,y,LET(b,FILTER(D3:D18,a=y),VSTACK(x,MATCH(b,SORT(b,1,-1),0))))),1))

复制代码

liuliu2024

1. =LET(a,SCAN(0,B3:B18>0,SUM),MAP(a,D3:D18,LAMBDA(m,n,SUM(N(n<(m=a)*D3:D18))+1)))

复制代码

大度的太阳

=SUM((N((SCAN(,$B$3:$B$18,CONCAT)=CONCAT($B$3:B3))*$D$3:$D$18>D3)))+1

我要成为专家

1. =MATCH(D3,SORT(FILTER($D$3:$D$18,SCAN(,$B$3:$B$18,LAMBDA(x,y,IF(y="",x,y)))=LOOKUP("坐",$B$3:B3)),,-1),)

复制代码

寻找王多鱼

liuliu2024 发表于 2025-6-18 17:19

SUM(N(n<(m=a)*D3:D18))+1)，这段公式是什么意思？一点都看不懂，请教一下