Hi all, I am a new member to this forum. I have an excel problem and I hope all the experts in here can help me out.

A,B,C
Diameter,thickness,ID
762,25.4,1324
762,25.4,1325
660,19,1496
660,15.9,5000
762,35,1462
762,35,1464

Note: column separated by comma (,)

From the list, I would like to get two corresponding ID that would give the max diameter with the corresponding max thickness. For example first answer will be max diameter is (762) corresponding max thickness is (35) and ID (1462). second answer will be max diameter is (762) corresponding max thickness is (35) and ID (1464).

Thanks..