Say the data is like:

frank 56
joe 9
frank 74
frank 101
jim 143
jim 146
joe 200
frank 164
joe 135
joe 127
joe 177
jim 10
jim 135
jim 53
frank 190
joe 109
jim 193
jim 29
jim 8
jim 107
joe 93
joe 9
jim 153
jim 186
joe 36
jim 174
jim 141
frank 55
jim 92
frank 141
joe 15
frank 5
frank 34
joe 161
jim 103
joe 88
and we want the max score for frank:

=MAX(IF(A1:A36="frank",B1:B36,""))
will return 190

NOTE this is an array formula that must be entered with CNTRL-SHFT-ENTER
rather than just the ENTER key.
--
Gary''s Student - gsnu201001


"Ron" wrote:

Hello all,

I'm looking to return the highest score for a users with multiple
scores in a list of other users with multiple scores.

Thank you,
Ron
.