In rows at the top (B1 - G1) I have six team names (text).
In the columns below B1 - G1 I have their scores.
The scores are cumulative so a summed total occurs in B39 to G39.
I want to print on a separate sheet the current highest score in the form of a leaderboard.
Here is an example:
B1 = Team 1 B39 = 400
C1 = Team 2 C39 = 150
D1 = Team 3 D39 = 225
E1 = Team 4 E39 = 180
F1 = Team 5 F39 = 210
G1 = Team 6 G39 = 345
So What I want printed is (in this form) on a separate sheet and to sort automatically.
Leaderboard Sheet2
A1 = 1st B1 = Team 1 C1 = 400
A2 = 2nd B2 = Team 6 C2 = 345
A3 = 3rd B3 = Team 3 C3 = 225
A4 = 4th B4 = Team 5 C4 = 210
A5 = 5th B5 = Team 4 C5 = 180
A6 = 6th B6 = Team 2 C6 = 150
This data, A1 to A6 I will just print. B1 to B6 is taken from the first sheet by finding first, second, third, fourth, fifth and sixth. C1 to C6 is also taken from the first sheet and prints the score by team.
From there I will do a podium to pick 1st, 2nd and 3rd for the podium, but I will base it on that automatic sorting.
And just one other thing, it is possible to have a tie (although unlikely) so I would like to have that somehow noted in the formula too.
Thanks in advance.
Just one more thing.... and this is a biggie. I need to do this on Google Sheets - so I am hoping there is some similarity.
In the columns below B1 - G1 I have their scores.
The scores are cumulative so a summed total occurs in B39 to G39.
I want to print on a separate sheet the current highest score in the form of a leaderboard.
Here is an example:
B1 = Team 1 B39 = 400
C1 = Team 2 C39 = 150
D1 = Team 3 D39 = 225
E1 = Team 4 E39 = 180
F1 = Team 5 F39 = 210
G1 = Team 6 G39 = 345
So What I want printed is (in this form) on a separate sheet and to sort automatically.
Leaderboard Sheet2
A1 = 1st B1 = Team 1 C1 = 400
A2 = 2nd B2 = Team 6 C2 = 345
A3 = 3rd B3 = Team 3 C3 = 225
A4 = 4th B4 = Team 5 C4 = 210
A5 = 5th B5 = Team 4 C5 = 180
A6 = 6th B6 = Team 2 C6 = 150
This data, A1 to A6 I will just print. B1 to B6 is taken from the first sheet by finding first, second, third, fourth, fifth and sixth. C1 to C6 is also taken from the first sheet and prints the score by team.
From there I will do a podium to pick 1st, 2nd and 3rd for the podium, but I will base it on that automatic sorting.
And just one other thing, it is possible to have a tie (although unlikely) so I would like to have that somehow noted in the formula too.
Thanks in advance.
Just one more thing.... and this is a biggie. I need to do this on Google Sheets - so I am hoping there is some similarity.
