View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Robert-Alpha[_2_] Robert-Alpha[_2_] is offline
external usenet poster
 
Posts: 10
Default choosing the a cell from a range

=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