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 |