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
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
Something like this ?
Book1
ABCD
1PlayerPointsLeadingLeading
2Player11Player2
3Player24
4Player33
Sheet2


Where 100 represents a reasonable end of data row.
 

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
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: ]
 

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
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...
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
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
Joined
Dec 4, 2002
Messages
323
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,123,104
Messages
5,599,746
Members
414,333
Latest member
willfrederick

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
Top