how do i MAX to display the person who got MAX

K

Konrad Walsh

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?
 
D

Dave Breitenbach

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
 
D

Dave Breitenbach

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)
 
A

Aladin Akyurek

Konrad said:
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?
Click to expand...

See my contrib in:

http://tinyurl.com/562xz
 
Top