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!

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!
================================================== ===

"stan" wrote in message
...
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!

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
"stan" wrote:

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!