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

tgydslr

游客，如果您要查看本帖隐藏内容请回复

rlz680926

1111111111111111

xuyouxm

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

复制代码

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

复制代码

as0810114

总算是弄出来了，加经验可以不，顺委。
=SUM(--IF(B$2:B$14&C$2:C$14>=B2&C2,MATCH(B$2:B$14&C$2:C$14,B$2:B$14&C$2:C$14,)=ROW($2:$14)-1))     93字符
数组公式。
60字符  =SUM(--IF(B:B&C:C>B2&C2,MATCH(B:B&C:C,B:B&C:C,)=ROW($1:$14)))
很卡的喔。

xiaoni

占位学习一下

Jerrycq

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

复制代码

渊怨缘

=SUM(N(FREQUENCY(IF(B$2:B$14*10+C$2:C$14>=B2*10+C2,B$2:B$14*10+C$2:C$14),B$2:B$14*10+C$2:C$14)>0))

晓晓的秋天

1. =SUM(--IF(B$2:B$14&C$2:C$14>=B2&C2,MATCH(B$2:B$14&C$2:C$14,B$2:B$14&C$2:C$14,)=ROW($1:$13)))

复制代码

qjsu

凑个热闹，公式比较长

幵吢の壞ㄝ孩

来看看，学习学习