Well, I think I got it! Players names in col 'C' from D6 to D20, POINTS in
col'D', and so on-

First I needed to 'see' which player had the Lowest and put this value in a
cell(ie:d37):
=small(d6:d20,((countif(c6:c20,"")+1))
Then, I use this number to find my player who this number matches to in next
cell (ie: d38):
=index(c6:i20,match(d37,d6:d20,FALSE),1)

Thanks for everyone's help!
Greatly appreciated!
Duane


"Duane" wrote:

HA!! Now I have another little glitch in my calculations!!!
I have the ability to have 15 boys on the team but we currently have only 12
so when I want to find the player with the 'MIN assists' it shows me the
entry where I don't have a boy because 'HE' (not listed) is '0'

I need some way to have my calculation IGNORE the entries if the Player name
is a NUL non entry.
Sorry if I am wasting your time but I am not that fluent with Excel yet!

Thanks again!
Duane