# Showing a cell that corosponds with the highest number

#### Matt_2K

##### New Member
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 a 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 that cell by 3 to get the points, ive also used sumif to find all the using games, and then i've taken it away. This shows the number in the points box. I need to find the row with the biggest number, and then display the cell to the left of it.

Does anyone know how I would do this?

Thanks

### Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

#### just_jon

##### Legend
Something like this ?
Book1
ABCD
2Player11Player2
3Player24
4Player33
Sheet2

Where 100 represents a reasonable end of data row.

#### just_jon

##### Legend
What do you want to have happen in the event of a tie for top scode? [Of course, if NateO's playing, not bloody likely, eh Nate you ol' sharpshooter you ]

#### Zack Barresse

##### MrExcel MVP
this is almost like jon's, slightly shorter as the MAX fx i a seperate formula...
Book1
BCDE
6a5
7b2
8c3
9d4
10b2
Sheet2

edit: c10 housed a max fx - lost in translation...

##### MrExcel MVP
Matt_2K said:
...

It's layed out like this

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

I would want it to show Player2 in the cell...

Can there be more than 1 player having the same highest score?

#### gaynard_nelson

##### Active Member
Matt_2K said:
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 a 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

Here is one way of doing it using the database function DGET.

Name Wins Wins
Player1 1 4 =MAX(B2:B4)
Player2 4
Player3 3 Player2 =DGET(A1:B4,1,D1:D2)

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,168,036
Messages
5,856,957
Members
431,841
Latest member
jaybeem

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back