[开_159]排名统计（已总结）

绊成ρìи

1. =TEXT({-1,1}%,VLOOKUP("*;*",SUBSTITUTE(LARGE(MMULT(B$2:M$8,Z1:Z12+1)+ROW($2:$8)%,ROW(A1)),".0"&ROW($2:8),";"&A$2:A8),1,))

复制代码

睡不着了qwe

1. =DROP(REDUCE(0,ROW($A$1:$A$7),LAMBDA(I,j,VSTACK(I,HSTACK(VLOOKUP(LARGE(BYROW(B2:M8,LAMBDA(x,SUM(x))),j),HSTACK(BYROW(B2:M8,LAMBDA(x,SUM(x))),A2:A8),2,0),LARGE(BYROW(B2:M8,LAMBDA(x,SUM(x))),j))))),1)

复制代码

丿丿丿戎

1. =FILTERXML(CONCAT("<a>","<b>"&A$2:A8&"<c>"&MMULT(B$2:M8-9^9*COUNTIF(O$1:P1,A$2:A8&""),N1:N12+1)&"</c></b>","</a>"),"a/b[not(//c>c)]"&{"","/c"})

复制代码

1. =TEXT(VLOOKUP("*0",IF({1,0},SUBSTITUTE(LARGE(MMULT(B$2:M$8,N1:N12+10)+ROW(1:7)%,ROW(A1)),ROW(1:7)%,".0"),A$2:A8),{2,1},),0)

复制代码

满坛皆为吾师

剑走偏峰，WPS P2:Q8区域数组

1. =TEXT({-1,1},EVALUATE(SUBSTITUTE(LARGE(MMULT(B2:M8,Z1:Z12+1)+ROW(1:7)%,ROW(1:7)),".0","&"";""&OFFSET(A1,")&",)"))

复制代码

小書生

先来一个，以后慢慢优化，来日方长：

1. =DROP(REDUCE(0,LARGE(MMULT(B2:M8,Z1:Z12+1)+ROW(2:8)%,ROW(1:7)),LAMBDA(x,y,VSTACK(x,HSTACK(INDEX(A:A,RIGHT(y)),INT(y))))),1)

复制代码

看见星光

只能引用一次。。。

1. =VLOOKUP(9^9,IF({1,0},--(LARGE(MMULT(B$2:M$8,Z1:Z12+1)+ROW(1:7)%,ROW(A1))-ROW(1:7)%&"."),A$2:A8),{2,1})

复制代码

cinlo

区域数组

1. =TEXT(MID(VLOOKUP(ROW()&"*",VLOOKUP("*"&ROW(),ROW()&LARGE(MMULT(B2:M8,Z1:Z12+1)+ROW()%,ROW()-1)+10^9,1,)&A2:A8,1,),{15,3},9),0)

复制代码

624134745

=VLOOKUP(LARGE(MMULT($B$2:$M$8,ROW($1:$12)^0),ROW(A1)),IF({1,0},SUBTOTAL(9,OFFSET($B$1:$M$1,ROW($1:$7),)),$A$2:$A$8),3-COLUMN(A1),)右拉下拉，重在参与了，当出现相同的销售额有BUG，还有就是OFFSET分别引用B2:M8不知道算不算引用2次

quqiyuan

1. =INDEX($A$2:$A$8,RIGHT(LARGE(MMULT($B$2:$M$8,ROW($1:$12)^0)/1%+ROW($1:$7),ROW(A1)),2))

复制代码

1. =LARGE(MMULT($B$2:$M$8,ROW($1:$12)^0),ROW(A1))

复制代码

梁锦鲤

1. =INDEX(IF({1,0},$A$2:$A$8,MMULT($B$2:$M$8,ROW($1:$12)^0)),RIGHT(LARGE(MMULT($B$2:$M$8,ROW($1:$12)^0)*10+ROW($1:$7),ROW(A1))),COLUMN(A1))

复制代码