how can i choose the highest number in excel range
Thank you,... it works, i am not sure how but it returned the correct answer.
"Peo Sjoblom" wrote:
=INDEX(A1:J1,MATCH(MAX(A2:J2),A2:J2,0))
adapt to fit your data
if there are more than one MAX value the first occurrence will be returned
--
Regards,
Peo Sjoblom
"Robert-Alpha" wrote in message
...
i want to automatically indicate the person with the higest score ...
Name Name Name Name Name
851.18 545.74 443.38 2,663.11 3,961.84
|