[已解决]数组小练习--中式排名（已经开帖）

风林火山

学习学习
=MATCH(B2+C2/10,LARGE(IF(MATCH($B$2:$B$14+$C$2:$C$14/10,$B$2:$B$14+$C$2:$C$14/10,)=ROW(A$2:A$14)-1,$B$2:$B$14+$C$2:$C$14/10),ROW(A$2:A$14)-1),)
=MATCH(B2+C2/10,LARGE(IF(FREQUENCY($B$2:$B$14+$C$2:$C$14/10,$B$2:$B$14+$C$2:$C$14/10),$B$2:$B$14+$C$2:$C$14/10),ROW($1:$13)),)

csmctjg

公式1：

1. =SUM((B$2:B$14/1%+C$2:C$14>=B2/1%+C2)*(MATCH(B$2:B$14&C$2:C$14,B$2:B$14&C$2:C$14,)=ROW($1:$13)))

复制代码

公式2：

1. =SUM(N(FREQUENCY(IF(B$2:B$14/1%+C$2:C$14>=B2/1%+C2,B$2:B$14/1%+C$2:C$14),B$2:B$14/1%+C$2:C$14)>0))

复制代码

公式3：

1. =SUM((B$2:B$14/1%+C$2:C$14>=B2/1%+C2)/MMULT(N(B$2:B$14&C$2:C$14=TRANSPOSE(B$2:B$14&C$2:C$14)),ROW($1:$13)^0))

复制代码

公式4（内存数组）：

1. =MMULT(-(B2:B14/1%+C2:C14<=TRANSPOSE(B2:B14/1%+C2:C14)),-(MATCH(B2:B14&C2:C14,B2:B14&C2:C14,)=ROW(1:13)))

复制代码

tuotuo865

我想了好久，最短的公式，必须是这个
在D2处输入=F2，然后下拉即可

呵呵！我实在是太笨了，只能偷奸耍滑了~

小志

参与一下。
不玩字符。。

1. =SUM((($B$2:$B$14*100+$C$2:$C$14)>=(B2*100+C2))/MMULT(N($B$2:$B$14*100+$C$2:$C$14=TRANSPOSE($B$2:$B$14*100+$C$2:$C$14)),ROW($1:$13)^0))

复制代码

雨后的风

1. =MATCH(B2:B14*10+C2:C14,LARGE(IF(FREQUENCY(B2:B14*10+C2:C14,B2:B14*10+C2:C14),B2:B14*10+C2:C14,0),ROW(1:14)),)

复制代码

qinqh_yl

中国式排名小练习.rar (7.59 KB, 下载次数: 3)

2013-5-20 11:07 上传

点击文件名下载附件

lyf7276

lyf7276 发表于 2013-5-15 10:22
=COUNT(1/(((B$2:B$14+C$2:C$14*0.1)>=(B2+C2*0.1))*(MATCH((B$2:B$14+C$2:C$14*0.1),(B$2:B$14+C$2:C$14*0 ...

顺大大起得早呀。我这是内存数组呀，是不是要额外加10BB呀

1091126096

学习学习