Hello,
For a soccer league I'm making a statistics spreadsheet.

For a top scorer for each team stat, I have a list of all of the scorers and their clubs with the amount of goals scored.

Column A Column B Column C
Player # Goals Club


Is there any way to make a formula that will sort through the data and get the player from each club with the most goals and place it into another cell?

Thanks,
afe5026

sorry about formatting with the columns - can't fix it