Highest Productive Employee

[Chandan]

Hi All,


I was working on an excel where I will have to retrieve the name of a person who has the highest productivity to another cell. below is the sample of the file. Can you please help me in arriving at a formula which pulls the name of the highest productive employee.

[pre]

Sl. No	Name	Units	Prodn hrs	Productivity
1	A	8	8	          100%
2	B	9	8	          113%
3	C	7	8	           88%
4	D	8	8	          100%
5	E	10	8	          125%
6	F	6	8                  75%
7	G	7	8	           88%
8	H	8	8	          100%
9	I	8	8	          100%
10	J	8	8	          100%
11	K	8	8	          100%
12	L	10	8	          125%
13	M	12	8	          150%

[/pre]
TEAM 109 104 105%


Best Performer "I WANT THE NAME HERE"

 

[jason]

Try this: this is assuming your data is located in A1:e14


=INDEX(A1:E14,MATCH(MAX(E2:E14),E1:E14,0),2)

 

[Chandan]

Thanks.. this works cool.. a glitch is that if two persons share the highest productivity, then this formula retrieves only one.

 

[jason]

correct... how would you like for multiples to be reported? this wil be a biy harder

 

[Sara]

Try this

http://www.youtube.com/watch?v=SCiqQiC7Bwk