Leader board lookup

[lochdara]

Hi Guys

I have attached a simple spreadsheet with a question i cant type correctly into google.
I have a score sheet and i simply want the team name and the highest score shown in a cell on the leaderboard worksheet.

Can you advise me on this?

[CRIMEDOG]

What I would probably do:
Add a couple of columns to the patterns tab (or any tab - then might hide them)
Total all the points in new column Overal score then =rank() formula in the next column
Then on the leaderboard tab you can use index() to set up the leaderboards
The issue I see would be ties.

You could also use Pivot table

[lochdara]

cheers..
I'll look at this..

Im still new to excel but will be using it for statistics soon from college so this will be good practice.