[FONT="][FONT="]Hello guys, I hope you can help.[/FONT][/FONT]
[FONT="][FONT="][/FONT]
[/FONT]
[FONT="][FONT="]I have a sheet that basically has names and scores, the names are in cells B3-B10 and their scores are in cells Z3-Z10. This is part of a scoreboard with other bits in between them so everything needs to stay where it is, however I would like to put a live 1st - 8th below it that will rank them in order, however rather than it just saying what position they’re in next to their score, I was hoping it would re order their names along with their scores in position order. (Cells A3-A10 would be #1 - #8).[/FONT][/FONT]
[FONT="][FONT="][/FONT]
[/FONT]
[FONT="][FONT="]For example, Phil gets 10 points and Paul gets 5, the list would show
[/FONT][FONT="]
[/FONT][/FONT]
<tbody>
</tbody>[FONT="][FONT="][/FONT]
[/FONT]
[FONT="]
[/FONT]
[FONT="][FONT="][/FONT]
[/FONT]
[FONT="][FONT="]However if Paul gets 10 more, as I update the scores in Z3-Z10 it would re order them and show
[/FONT][FONT="]
[/FONT][/FONT]
<tbody>
</tbody>[FONT="]
[/FONT]
[FONT="][FONT="][/FONT]
[/FONT]
[FONT="][FONT="]But for 8. Is this possible?
Thanks.[/FONT][/FONT]
[FONT="][FONT="][/FONT]
[/FONT]
[FONT="][FONT="]I have a sheet that basically has names and scores, the names are in cells B3-B10 and their scores are in cells Z3-Z10. This is part of a scoreboard with other bits in between them so everything needs to stay where it is, however I would like to put a live 1st - 8th below it that will rank them in order, however rather than it just saying what position they’re in next to their score, I was hoping it would re order their names along with their scores in position order. (Cells A3-A10 would be #1 - #8).[/FONT][/FONT]
[FONT="][FONT="][/FONT]
[/FONT]
[FONT="][FONT="]For example, Phil gets 10 points and Paul gets 5, the list would show
[/FONT][FONT="]
[/FONT][/FONT]
Rank | Name | Score |
#1 | Phil | 10 |
#2 | Paul | 5 |
<tbody>
</tbody>
[/FONT]
[FONT="]
[/FONT]
[FONT="][FONT="][/FONT]
[/FONT]
[FONT="][FONT="]However if Paul gets 10 more, as I update the scores in Z3-Z10 it would re order them and show
[/FONT][FONT="]
[/FONT][/FONT]
Rank | Name | Score |
#1 | Paul | 15 |
#2 | Phil | 10 |
<tbody>
</tbody>
[/FONT]
[FONT="][FONT="][/FONT]
[/FONT]
[FONT="][FONT="]But for 8. Is this possible?
Thanks.[/FONT][/FONT]