I am collecting statistics for a basketball recreation league. I have a file for every team in the league and we give awards for those with the most total points, ect. I know how to use the MAX function, but I wanted to use another file for the leaderboard. My problem is that the points total is in column J and the players names are in column C. What formula can you use so that it finds the max number AND also pulls the players name that accomplished the feat at the same time?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Correct max formula question
- Thread starter bgredmchn
- Start date
venkat1926
Well-known Member
- Joined
- Aug 21, 2005
- Messages
- 4,824
are the players name in column c is like this
john, jerry, jacbo in c2
nicholas, rv, venkat in c3 etc
that is all the names of one team in one cell in column C
please clarify
if possible post a very small extrct
you heve to use soemthing like
=max(if(...........)
john, jerry, jacbo in c2
nicholas, rv, venkat in c3 etc
that is all the names of one team in one cell in column C
please clarify
if possible post a very small extrct
you heve to use soemthing like
=max(if(...........)
Upvote
0
