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.
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 |