choosing a cell from a range
 

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: 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

choosing a cell from a range
 

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" wrote in message
...
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: 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