If Largest Data Pull Name.. Help!

[stan]

Hello,

I have two columns one with numbers and another with corresponding names. I
want excel to display the names of the largest value and the smallest value.
How would I go about doing this?

Thanks!

 

[RagDyeR]

With numbers in Column A and names in Column B, try these:

=INDEX(B:B,MATCH(MAX(A:A),A:A,0))

=INDEX(B:B,MATCH(MIN(A:A),A:A,0))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Hello,

I have two columns one with numbers and another with corresponding names. I
want excel to display the names of the largest value and the smallest value.
How would I go about doing this?

Thanks!

 

[FSt1]

hi
use min and max with lookup.
=LOOKUP(MAX(A3:A600),A3:A600,B3:B600)
=LOOKUP(MIN(A3:A600),A3:A600,B3:B600)
where column a contains the values and column b contains the names
adjust to fit your data.

Regards
FSt1