Ranking, Names & Scores

[shah_ir85]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[TD="align: center"]E
[/TD]
[TD="align: center"]F
[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD]Name
[/TD]
[TD]Score
[/TD]
[TD][/TD]
[TD]Rank
[/TD]
[TD]Score
[/TD]
[TD]Name
[/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD]Player A
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]1
[/TD]
[TD]5
[/TD]
[TD]Player E
[/TD]
[/TR]
[TR]
[TD="align: center"]3
[/TD]
[TD]Player B
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD]2
[/TD]
[TD]4
[/TD]
[TD]Player D
[/TD]
[/TR]
[TR]
[TD="align: center"]4
[/TD]
[TD]Player C
[/TD]
[TD]3
[/TD]
[TD][/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]Player C
[/TD]
[/TR]
[TR]
[TD="align: center"]5
[/TD]
[TD]Player D
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Player H
[/TD]
[/TR]
[TR]
[TD="align: center"]6
[/TD]
[TD]Player E
[/TD]
[TD]5
[/TD]
[TD][/TD]
[TD]4
[/TD]
[TD]2
[/TD]
[TD]Player B
[/TD]
[/TR]
[TR]
[TD="align: center"]7
[/TD]
[TD]Player F
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Player G
[/TD]
[/TR]
[TR]
[TD="align: center"]8
[/TD]
[TD]Player G
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD]5
[/TD]
[TD]1
[/TD]
[TD]Player A
[/TD]
[/TR]
[TR]
[TD="align: center"]9
[/TD]
[TD]Player H
[/TD]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Player F
[/TD]
[/TR]
</tbody>[/TABLE]

hye mate...i have small problem with ranking...base on score....
please help me if u understand.....the empty cell and D5,E5,D7,E7, D9 & E9....
please help me to get formula for D, E and F...tQ

 

[Marcelo Branco]

oops...the formulas above fail in some situations. Re-thinking...

CORRECTION
Formula in E2 copied down
=IF(D2="","",LARGE($B$2:$B$9,ROWS(E$2:E2)))
Enter

The array formulas in D2 and F2 are correct

M.

 

[shah_ir85]

oops...the formulas above fail in some situations. Re-thinking...

CORRECTION
Formula in E2 copied down
=IF(D2="","",LARGE($B$2:$B$9,ROWS(E$2:E2)))
Enter

The array formulas in D2 and F2 are correct

M.

Really appreciate. tQSM mate :P