View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jamesjohns82 jamesjohns82 is offline
external usenet poster
 
Posts: 2
Default Possible to "understand and pull" highest value from column B.....

My questions is this:

Is it possible to understand and pull the highest value from column B, then
"read" across to column A to pull specific name associated with the highest
value.

Column A Column B Column C
George 15 **George** (After understanding
high value)
Mike 12

Effectively I want a formula for excel to search for highest value in column
B, then effectively pull the name associated with the highest value to Column
C.


Is this possible?