max in on column, description in another
I want to find the highest number in column B and show the name
associated with that number.
A B
John 123
frank 224
joe 110
frank 224 This would show the name and the associated
number.
Is there a function that will do this?
|