Showing a cell that corosponds with the highest number

Matt_2K

New Member
Joined
Feb 15, 2004
Messages
1
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

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Something like this ?
Book1
ABCD
1PlayerPointsLeadingLeading
2Player11Player2
3Player24
4Player33
Sheet2


Where 100 represents a reasonable end of data row.
 
Upvote 0
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 :LOL: ]
 
Upvote 0
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...
 
Upvote 0
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?
 
Upvote 0
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)
 
Upvote 0

Forum statistics

Threads
1,213,483
Messages
6,113,919
Members
448,533
Latest member
thietbibeboiwasaco

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top