Good morning,

I have an Excel file with two sheets, sheet 1 contains two columns of data,
column A has text and column B has numbers. In sheet 2, I have a list if
unique text that matches that in column A of sheet 1. I need to place a
formula alongside the unique list in sheet 2 to return the highest
corresponding value in sheet 1 i.e. the value in column B.

Below is an example of what I'm looking to achieve. Any pointers most
welcome.

Thanks, Rob

col a col b
01 30
02 29
01 31
02 30
01 34

col c col d
01 want to return 34
02 want to return 30