choosing the a cell from a range

G

Guest

=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
 
G

Guest

works great... 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 warning or can i show both names?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel maxa 4
formula to display cell address 2
making sure a cell in an array is not duplicated 2
choosing a cell from a range 1
Target cell reference moves when target is cut and pasted 5
Lookup a particular cell in another excel workbook 1
How to determine the value? 3
Sumif less than x 3

Top