Hi,

Is this what you want

=INDEX(A3:A30,MATCH(MAX(B3:B30),B3:B30,FALSE),1)

change MAX to MIN for the minumum assists etc
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Duane" wrote:

Morning folks: I am trying to do something very simple but I just can't seem
to get it to work the way I want! I have been searching for an answer for 2
days now!!!

On my STATS page I have a list of basketball players down a column (taken
from TEAM LIST page) and the next columns have their POINTS, REBOUNDS,
ASSISTS, etc. (taken from GAMES DATA page)
At the bottom, I want to see who has the most points: '=MAX(B3:B30)' and I
would like to show that players name next to the number returned from MAX.
The same for '=MIN(B3:B30)'
I think my problem is that player #1 may have a higher number than Player#23
and my calculation returns 'N/A', am I right thinking this? Am I getting
caught on some restrictions I don't know about?

Thanks for all your help!
Regards;
Duane in Nova Scotia

John 4 6 2
Sean 12 2 1
Todd 0 2 1
Andy 6 1 0
Brad 23 4 8
Vern 2 0 0
Mark 8 4 2