how do i MAX to display the person who got MAX
 

Hi
I am using the excel function MAX to display the highest seller out of my
sale team. While this works perfect, How do i get it to display the name of
the person got the highest which is is the cell to the left of it?

Konrad,

try thiese formulas for example...

A B C D
2 Name sold formulas
3
4 joe 500
5 dave 1000
6 steve 1500
7
8 max sold 1500 =MAX(B3:B5)
9 max seller steve =INDEX(A3:A5,MATCH(B7,B3:B5),1)
10
11 combine above formulas into one cell:
12 steve =INDEX(A3:A5,MATCH(MAX(B3:B5),B3:B5),1)



hth,
Dave
"Konrad Walsh" wrote:

Hi
I am using the excel function MAX to display the highest seller out of my
sale team. While this works perfect, How do i get it to display the name of
the person got the highest which is is the cell to the left of it?

oops, a couple of unupdated references - here ya go...
A B C D
2 Name sold formulas
3
4 joe 500
5 dave 1000
6 steve 1500
7
8 max sold 1500 =MAX(C4:C6)
9 max seller steve =INDEX(B4:B6,MATCH(C8,C4:C6),1)
10
11 combine above formulas into one cell:
12 steve =INDEX(B4:B6,MATCH(MAX(C4:C6),C4:C6),1)



"Konrad Walsh" wrote:

Hi
I am using the excel function MAX to display the highest seller out of my
sale team. While this works perfect, How do i get it to display the name of
the person got the highest which is is the cell to the left of it?

Konrad Walsh wrote:
Hi
I am using the excel function MAX to display the highest seller out of my
sale team. While this works perfect, How do i get it to display the name of
the person got the highest which is is the cell to the left of it?

See my contrib in:

http://tinyurl.com/562xz