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