|
楼主 |
发表于 2010-5-22 08:19
|
显示全部楼层
排名的相关帖子及方法:
多条件排名 http://club.excelhome.net/thread-577840-1-1.html
=SUMPRODUCT(($A$1:$A$7=A1)*($B$1:$B$7>B1))+1
=SUM(N(IF($A$1:$A$12=A10,B10<$B$1:$B$12)))+1
学校考试成绩多条件排名 http://club.excelhome.net/thread-502269-1-1.html
中式排名
语文年级=IF(LEFT(A2)="7",MATCH(C2,LARGE(IF(IF(LEFT(A$2:A$266)="7",MATCH(C$2:C$266,IF(LEFT(A$2:A$266)="7",C$2:C$266),),"")=ROW(C$2:C$266)-1,C$2:C$266,""),ROW(C$2:C$266)-1),),MATCH(C2,LARGE(IF(IF(LEFT(A$2:A$266)="8",MATCH(C$2:C$266,IF(LEFT(A$2:A$266)="8",C$2:C$266),),"")=ROW(C$2:C$266)-1,C$2:C$266,""),ROW(C$2:C$266)-1),))
语文班级=MATCH(C2,LARGE(IF(IF((A$2:A$266)*1=A2,MATCH(C$2:C$266,IF((A$2:A$266)*1=A2,C$2:C$266),),"")=ROW(C$2:C$266)-1,C$2:C$266,""),ROW(C$2:C$266)-1),)
如何求排名啊,高手们帮帮忙,谢谢!http://club.excelhome.net/viewth ... C5%C3%FB&page=1
大头老师给出的方法:
=MATCH(D3,LARGE(IF(ISNUMBER(1/(MATCH(B3&"@"&D$3:D$41,B$3:B$41&"@"&D$3:D$41,)=ROW($1:$39))),D$3:D$41),ROW($1:$200)),)
[ 本帖最后由 lhx120824 于 2010-5-22 11:14 编辑 ] |
|