how can i choose the highest number in excel range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert-Alpha - 12 Sep 2007 17:12 GMT

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

Reply to this Message

Don Guillett - 12 Sep 2007 17:43 GMT

Have a look in the help index for MAX and then OFFSET

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

>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

Reply to this Message

Peo Sjoblom - 12 Sep 2007 17:45 GMT

=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

Signature

Regards,

Peo Sjoblom

>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

Reply to this Message

Robert-Alpha - 12 Sep 2007 19:14 GMT

Thank you,... it works, i am not sure how but it returned the correct answer.

> =INDEX(A1:J1,MATCH(MAX(A2:J2),A2:J2,0))
>
[quoted text clipped - 6 lines]
> > Name Name Name Name Name
> > 851.18 545.74 443.38 2,663.11 3,961.84

Reply to this Message

David Hilberg - 12 Sep 2007 18:57 GMT

Select the names.
Format with Conditional Formatting.
Formula is =A2=MAX(A$2:F$2)
(Assuming scores in A2:F2)
Format as Bold (or whatever you please).

The name(s) of the top scorer(s) will appear in bold.

- David
xl2003

> 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

Reply to this Message