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?

max in on column, description in another
 

In Cell B4 enter

=Max(B1:B3)

In cell A4 enter

=INDEX(A1:A3,(MATCH(B4,B1:B3,0)))

" wrote:

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?

max in on column, description in another
 

How about combining into a single formula:

=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"AKphidelt" wrote in message
...
In Cell B4 enter

=Max(B1:B3)

In cell A4 enter

=INDEX(A1:A3,(MATCH(B4,B1:B3,0)))

" wrote:

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?