"Bernard Liengme" wrote in message
...
Starting in A1, I have
Dora 12
Jack 15
Emma 10


The name of the winner is picked out by
=INDEX(A1:A3,MATCH(MAX(B1:B3),B1:B3))


Why complicate? Why not just sort and the winner is at the top? KISS!!!!!

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)