Finding maximum against a value

[kalucharan]

Could anyone help me with the formula for below problem.
I need to find the item name with the maximum price in a new column against the name.
Attached the excel for the reference.

Name	Item Name	Price	Expected Result	Formula?
Harry	A	20​	C
	B	67​
	C	87​
	D	87​
Tom	A1	25​	E1
	B1	69​
	C1	78​
	D1	79​
	E1	87​

 

[zero269]

Could anyone help me with the formula for below problem.
I need to find the item name with the maximum price in a new column against the name.
Attached the excel for the reference.

Name	Item Name	Price	Expected Result	Formula?
Harry	A	20​	C
	B	67​
	C	87​
	D	87​
Tom	A1	25​	E1
	B1	69​
	C1	78​
	D1	79​
	E1	87​

What formula are you currently working with?
Also, can you use the forums Excel Add-in to share your data? It makes it easier for people to assist you.
It's located here: XL2BB - Excel Range to BBCode

 

[kalucharan]

Could anyone help me with the formula for below problem.
I need to find the item name with the maximum price in a new column against the name.
Attached the excel for the reference.

Name	Item Name	Price	Expected Result	Formula?
Harry	A	20​	C
	B	67​
	C	87​
	D	87​
Tom	A1	25​	E1
	B1	69​
	C1	78​
	D1	79​
	E1	87​

Could anyone help me with the formula for below problem.
I need to find the item name with the maximum price in a new column against the name.
Attached the excel for the reference.

Name	Item Name	Price	Expected Result	Formula?
Harry	A	20​	C
	B	67​
	C	87​
	D	87​
Tom	A1	25​	E1
	B1	69​
	C1	78​
	D1	79​
	E1	87​

Could anyone help me with the formula for below problem.
I need to find the item name with the maximum price in a new column against the name.
Attached the excel for the reference.

Name	Item Name	Price	Expected Result	Formula?
Harry	A	20​	C
	B	67​
	C	87​
	D	87​
Tom	A1	25​	E1
	B1	69​
	C1	78​
	D1	79​
	E1	87​

I am using 2016 version. After pivot I get above format. Then I will consider only Item Name with maximum price against the name. I think above problem can be solved using vlookup and max function and freezing cells. Any help is highly appreciated.
Thanks in advance.