Ranking outcome

[ANTONPRINSLOO]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD] NAME

[/TD]
[TD]NUMBER
[/TD]
[TD]WEIGHT
[/TD]
[TD]POINTS
[/TD]
[TD]RANK
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JOHN
[/TD]
[TD]1
[/TD]
[TD]0.5
[/TD]
[TD]15
[/TD]
[TD]5
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PETER
[/TD]
[TD]5
[/TD]
[TD]5.0
[/TD]
[TD]100
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GERRY
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CHARLES
[/TD]
[TD]2
[/TD]
[TD]4
[/TD]
[TD]60
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TANK
[/TD]
[TD]3
[/TD]
[TD]6
[/TD]
[TD]50
[/TD]
[TD]3
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BILL
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]40
[/TD]
[TD]4
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1ST PLACE
[/TD]
[TD]2ND
[/TD]
[TD]3RD
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]NAME?
[/TD]
[TD]NAME?
[/TD]
[TD]NAME?
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Good day all,

please assist me with a formula to get the 1st, 2nd and 3rd place players name in a new block.



COLOM D CONTAINS A FORMULA TO GET TO POINTS. COLOM E CONTAINS A FORMLA O GET TO RANK.

I AM LOOKING FOR A FORMULA TO GET THE NAMES FOR 1st, 2nd and 3rd place players IN A SEPERATE BLOCK ON ANOTHER SHEET.

---

---

 

[James006]

Hello,

Not sure to understand ...

Don't you have the Rank in Column E ... ?

 

[ANTONPRINSLOO]

Yes I do but I want a shotcut that only shows the name

 

[James006]

For the First : =INDEX(A:A,MATCH(1,E:E,0))
For the Second : =INDEX(A:A,MATCH(2,E:E,0))
etc ...

Hope this will help

 

[ANTONPRINSLOO]

thank you

 

[James006]

You are welcome ...

 

[ANTONPRINSLOO]

Hi James,

Because of different divisions I amended the formula to =INDEX(A7:A67,MATCH(1,BW7:BW67,0))
as it is specific to those rows


EXEL shows an error.

I there something wrong with my changes?

 

[James006]

Hello Anton,

From the formula you posted ... no mistake ...

You just have to make sure :

1. BW7:BW67 contain the correct Rank formula

2. A7:A67 contain all your Names ...

Hope this will help