Showing a cell that corosponds with the highest number

[Matt_2K]

I am making a results table for pool games.

I've got it to calculate the points (3 for a win) and (take 1 for
loss) but I want it to show the players name that has the most points

It's layed out like this

--------------Points
Player1------ 1
Player2------ 4
Player3------ 3

I would want it to show Player2 in the cell.

I have used sumif to find all the winning games, then i've times tha
cell by 3 to get the points, ive also used sumif to find all the usin
games, and then i've taken it away. This shows the number in the point
box. I need to find the row with the biggest number, and then displa
the cell to the left of it.

Does anyone know how I would do this?

Thank

 

[Frank Kabel]

Hi
if you want to get the player's name with the highest score you may use
the following (assumption: col A stores the player's names and col B
the associated scores):
=INDEX($A$1:$A$100,MATCH(MAX($B$1:$B$100),$B$1:$B$100,0),0)

 

[Matt_2K]

Thankyou very much, it does work, but if the scores are equal, it wil
show player1. Can I make it say "No winner so far"

Thank

 

[Frank Kabel]

Hi
try something like
=IF(COUNTIF($B$1:$B$100,MAX($B$1:$B$100))>1,"no winner so
far",INDEX($A$1:$A$100,MATCH(MAX($B$1:$B$100),$B$1:$B$100,0),0))

 

[Matt_2K]

It works, thankyou

 

[Frank Kabel]

Hi
thanks for the feedback

 

[Matt_2K]

I worked out how to do the lowest points, by changing max with min. But
how would I go about getting the data for the person in second place?

Thanks

 

[Frank Kabel]

Hi
instead of MAX use LARGE (or SMALL). e.g.
=INDEX($A$1:$A$100,MATCH(LARGE($B$1:$B$100,2),$B$1:$B$100,0),0)

 

[Matt_2K]

Thankyou for the quick reply.

How can I make to so, if cell A5 is ... (3 dots) then B55 has ... (
dots) in it aswell?

Thank

 

[Frank Kabel]

Hi
sorry I don't understand your question :-(

 

[Matt_2K]

Don't worry the, I don't really need i

 

[Frank Kabel]

after rereading you may look for the IF function?
e.g. put this in D5: =IF(A5="...",A5,"")
just a guess