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 |