Display max

[leniw]

Hello All!

I have a table like this:

Column A Column B
Person 1 1.000
Person 2 2.800
Person 3 3.000

What I want to do is:

a) find the max value in column B
(Ok, I know how to this: =max(B1:B10)

b) display the Person who has the maximun value

Column A Column B
Person 1 1.000
Person 2 2.800
Person 3 3.000
maximum: 3.000
salesman: Person 3

IS THERE A WAY TO DO IT????

PLS HELP ME!!!

THANKS IN ADVANCE

lENA

 

[SkipVought]

Hi,

Take a look at Format/Conditional Formatting.

or

Data/Get External Data to query the MAX

or

[tt]
=INDEX(A1:A3,MATCH(MAX(B1:B3),B1:B3,0),1)
=MAX(B1:B3)
[/tt]


Skip,
[sub]
[red][/red]
[/sub]

 

[yogia]

Hi leniw:

In addition to the fine solution by Skip, (with your data in cells A1:B4) here is one more way ...

Person 1	1.000		maximum	   3.000
Person 2	2.800		salesman   Person 3
Person 3	3.000			
Person 4	2.654

formula for maximum is ... =MAX(B:B)
and
formula for salesman is ... =LOOKUP(1,1/(B1:B4=MAX(B:B)),A:A)


Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com

 

[leniw]

Many thanks to both of you!!!

Lena