Zend certified PHP/Magento developer

Excel – Display only max value from multiple criteria

Need help with an Excel function to display only the high scorer in the High Score column. Example Adam is best Golf and John is best in Tennis

Player Game Score High Score
Adam Golf 99.00 Adam
Bill Golf 85.00
John Golf 73.00
Adam Tennis 25.00
Bill Tennis 54.00
John Tennis 79.00 John