kalucharan
New Member
- Joined
- Mar 23, 2014
- Messages
- 8
- Office Version
- 2016
- Platform
- Windows
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.
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 |