Highest valued cell on another worksheet

[sheldon8]

i need to find the highest price for each part number. Part numbers, some multiple of the same with different revisions, are listed in column A, revisions in column B. the revisions at time have different prices. I need to have one part number, with the highest, most recent rev and the corresponding price on sheet2, which has the duplicates removed. can anyone help me out with this? i have tried everything i know...
hope this makes sense, file attached