Macro to display highest value for a given range.

[Harishmz]

Hi team,

please could you help with a macro to solve the below problem?
I have 2 columns - column 1 and column 2 with the below sample values. p1 is the highest value and p4 is the least value. Column 2 is a text column.
I want the highest value to be displayed in column 3 - "Output" based on column1.
For the range "Apples", the highest value is p1, orange it is p2 and grapes it is p4.

Column 1	Column 2	Output
Apples	p3	p1
Apples	p1	p1
Apples	p2	p1
Apples	p4	p1
Orange	p3	p2
Orange	p2	p2
Orange	p3	p2
Grapes	p4	p4

 

[Harishmz]

If it is really in alphabetic order, then one simple way would be to do the following:
1. Sort your data, primary sort on column A, secondary sort on column B, in ascending order.
2. Place this formula in cell C2 and copy down for all rows:

=IF(A2=A1,C1,B2)

Thank you very much for your quick response. I did try this formula and it perfectly worked. Much appreciated.

 

[Joe4]

You are welcome.