Cell isn't in column B, it's currently E5.
TWK

"Toobi-Won Kenobi" wrote in message
...
Using one of the two formulas below to display the name (from column B) of
the highest scorer (from column C) in another cell (E*)
is it possible to modify either to display the highest four placings?
How would I allow for a tied score.

=OFFSET(C1,MATCH(MAX(C1:C10),$C$1:$C$10,0)-1,-1,1,1)
or
=INDEX(B:B,MATCH(MAX(C:C),C:C,0))

Regards
TWK