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

ChangeKing7

581个字符。。。我是来学习的

499279666

1. =INDEX(IF({1,0},A2:A8,MMULT(B2:M8,V1:V12+1)),MATCH(LARGE(MMULT(OFFSET(A2:A8,,1,,12),V1:V12+1),ROW(1:7)),MMULT(OFFSET(A2:A8,,1,,12),V1:V12+1),),{1,2})

复制代码

丢丢表格

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

复制代码

行区域 数组公式 。

晨光晞微

1. =INDEX(IF({1,0},A2:A8,SUBTOTAL(9,OFFSET(B1:M1,ROW(1:7),))),RIGHT(LARGE(MMULT(B2:M8,Z1:Z12+1)+ROW(1:7)%,ROW(1:7))),{1,2})

复制代码

mystic23

1. =MAP(RIGHT(LARGE(MMULT(B2:M8,Z1:Z12+1)+ROW()%,ROW()-1),{1,99}),LAMBDA(x,IF(LEN(x)>1,INT(x),INDEX(A:A,x))))

复制代码

人间油物

不好意思啊，游灿大哥，你的要求里面没有说不能用WPS，而且我也确实是只引用了一次B2:M8区域。
右拉下拉，121字符

1. =IF(N$1=0,INDEX(A:A,RIGHT(LARGE(MMULT(B$2:M$8,Y1:Y12+1)+ROW($2:$8)%,ROW(A1)))),INT(EVALUATE(MID(FORMULATEXT(O2),28,50))))

复制代码

江山社稷

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

复制代码

区域数组

1. =LAMBDA(x,HSTACK(INDEX(A:A,RIGHT(x)),INT(x)))(LARGE(MMULT(B2:M8,Z1:Z12+1)+ROW()%,ROW()-1))

复制代码

右拉下拉

1. =IF(O2>9,SUBTOTAL(9,OFFSET($A$1,MATCH(O2,$A:$A,)-1,,,13)),INDEX(A:A,RIGHT(LARGE(MMULT(B$2:M$8,Z1:Z12+1)+ROW($2:$8)%,ROW(A1)))))

复制代码

1. =IF(O2>9,SUBTOTAL(9,OFFSET(A$1,MATCH(O2,$A:$A,)-1,,,12)),INDEX(A:A,RIGHT(LARGE(MMULT(B$2:M$8,Z1:Z12+1)+ROW($2:$8)%,ROW(A1)))))

复制代码

1. =IF(O2>9,SUM(OFFSET(A$1:L$1,MATCH(O2,$A:$A,)-1,)),INDEX(A:A,RIGHT(LARGE(MMULT(B$2:M$8,Z1:Z12+1)+ROW($2:$8)%,ROW(A1)))))

复制代码

℡Soul

1. =INDEX(IF({1,0},A2:A8,MMULT(B2:M8,R2:R13+1)),RIGHT(LARGE(MMULT(B2:M8,R2:R13+1)/1%+ROW(1:7),ROW(1:7))),{1,2})

复制代码

hbalyz

P2=INDEX($A$2:$A$8,MOD(LARGE(SUBTOTAL(9,OFFSET($B$1:$M$1,ROW($1:$7),))*100+ROW($1:$7),ROW(A1)),100))
Q2=LARGE(SUBTOTAL(9,OFFSET($B$1:$M$1,ROW($1:$7),)),ROW(A1))

静听溪流

107字符

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

复制代码

103字符

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

复制代码