Using the function below i get the answer i am looking for... however, what
if two people have the same exact score? it looks like based on the function
below the first occurance is picked up... can i build some kind of warnning
or can i show both names?

Subject: RE: choosing the a cell from a range 9/12/2007 12:57 PM PST

By: excelent In: microsoft.public.excel.misc

=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0))

"Robert-Alpha" skrev:

> =IF(B1=(LARGE($B$1:$B$10,{1})),B1,"") based on the formula to the left i am
> able to identify the highest scoring person. However, now i want to display
> that person's name a separate cell on top of the sheet.... so, i need a
> function that looks at column C1:C10 and returns "Sue"
>
> Or instead of having to do the formula above... have a funtions that looks
> at the data and returns "Sue"
>
> Thank you in advance for your help!
>
>
> Joe 1
> Robert 2
> Steve 5
> Sebastian 6
> Karen 10
> Sue 50 50
> Bernice 30
> Mary 40
> Ben 9
> Dan 10
>

The easiest way would be to use autofilter, then from the dropdown select
top 10, adjust it to top 1 and all max values will be displayed


--
Regards,

Peo Sjoblom




"Robert-Alpha" <(E-Mail Removed)> wrote in message
news:083D4745-A24D-48F6-A99C-(E-Mail Removed)...
> Using the function below i get the answer i am looking for... however,
> what
> if two people have the same exact score? it looks like based on the
> function
> below the first occurance is picked up... can i build some kind of
> warnning
> or can i show both names?
>
> Subject: RE: choosing the a cell from a range 9/12/2007 12:57 PM PST
>
> By: excelent In: microsoft.public.excel.misc
>
> =INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0))
>
> "Robert-Alpha" skrev:
>
>> =IF(B1=(LARGE($B$1:$B$10,{1})),B1,"") based on the formula to the left i
>> am
>> able to identify the highest scoring person. However, now i want to
>> display
>> that person's name a separate cell on top of the sheet.... so, i need a
>> function that looks at column C1:C10 and returns "Sue"
>>
>> Or instead of having to do the formula above... have a funtions that
>> looks
>> at the data and returns "Sue"
>>
>> Thank you in advance for your help!
>>
>>
>> Joe 1
>> Robert 2
>> Steve 5
>> Sebastian 6
>> Karen 10
>> Sue 50 50
>> Bernice 30
>> Mary 40
>> Ben 9
>> Dan 10
>>
>