Pulling data from cell next to largest value?

[kayskei]

Hello!

(fake data in screenshot, just made up to make it easier to explain what I'm trying to do)

I've got the pivot table in the above screenshot with hours that staff have spent teaching in each discipline, I need to populate the table below that with the discipline that the staff member has the highest number of hours in. For example, because Staff 1 has the most hours in Economics, I need to pull Economics though as the Main Discipline.

Is there a formula I can use to do this or is there something I can do with the pivot table?

Thanks for the help!

 

[Muhammad_Usman]

Receip.xlsm
	A	B	C	D	E
2			Displine	Hour
3	Staff1		Bussiness	36
4	Staff1		Eco	80
5	Staff1		Fin	67
6	Staff2		Bussiness	108
7	Staff2		Mkt	57
8
9
10
11	Staff1		Eco
12	staff2		Bussiness
13
14
15
s_k=discount+items&crid=1LU (2)

Cell Formulas
Range	Formula
C11:C12	C11	=INDEX($C$3:$C$7,MATCH(1,($A$3:$A$7=A11)*($D$3:$D$7=MAX(IF($A$3:$A$7=A11,$D$3:$D$7))),0))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[kayskei]

Receip.xlsm
	A	B	C	D	E
2			Displine	Hour
3	Staff1		Bussiness	36
4	Staff1		Eco	80
5	Staff1		Fin	67
6	Staff2		Bussiness	108
7	Staff2		Mkt	57
8
9
10
11	Staff1		Eco
12	staff2		Bussiness
13
14
15
s_k=discount+items&crid=1LU (2)

Cell Formulas
Range	Formula
C11:C12	C11	=INDEX($C$3:$C$7,MATCH(1,($A$3:$A$7=A11)*($D$3:$D$7=MAX(IF($A$3:$A$7=A11,$D$3:$D$7))),0))
Press CTRL+SHIFT+ENTER to enter array formulas.

That worked perfectly, thank you!!

 

[Muhammad_Usman]

That worked perfectly, thank you!!

Glad to Help You