[Solved] How to create a Music Trivia Scoreboard

[TamzBiz]

Good Day

I would like to organize a Music Trivia Evening for our church. I however would like to create a scoreboard for this activity to help keep teams motivated and enthusiastic to play by seeing their progress after each round of questions.

I am planning at least 20 rounds of questions and after each round i want to input the teams scores, and I need the leader board to re-arrange according to who is leading etc.
So if a team moved up from the last position your score turns green, if a team moved down it turns red and if a team stayed in that position it stays blue.

If anyone can assist me with an idea as to how I can create this Scoreboard I would appreciate it greatly.

Thank you

Paul

[Alex1]

Here's an example. The requirement to show movements with colours made it quite complicated, because it requires calculation of both the current and the previous scores. The old scores table and the Order and Row columns on the Score sheet can be hidden if necessary. Scores should be integer numbers, otherwise a different way of ordening is necessary.

[TamzBiz]

@Alex1
Thank you for trying to help me, I tried opening your example and it is read only so I can't enter any data to see how it works.

I have an example so long but I find that I manually have to sort it after each round to get the order right according to rank

[ken johnson]

Use "Save As" to save an editable copy of Alex's doc in your Documents.

Ken Johnson

[TamzBiz]

@Alex1 @Ken Johnson

Is there a way I can sort out the scorecard according to the rank after each round automatically and not manually as In my example after each round according to the rank in column X

[MrProgrammer]

s there a way I can sort out the scorecard according to the rank after each round automatically and not manually as In my example after each round according to the rank in column X

[Tutorial] Sorting and Filtering data with formulas

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Alex1]

@Alex1 @Ken Johnson

Is there a way I can sort out the scorecard according to the rank after each round automatically and not manually as In my example after each round according to the rank in column X

That's what my example does, but if you don't know how to save and open a file I can't help you.

[ken johnson]

In the attached doc column Z shows the teams in rank order.
Columns Y, AB and AC can be hidden.

Ken Johnson

[TamzBiz]

Thank you to @Alex1 @Ken Johnson @MrProgrammer
Ken Johnson took my idea and vastly improved my effort, Thank you so much Ken.
I am so greatful to all 3 of you for assisting me, I am self taught and I try learn every day so I hope to learn what each formulae does but I will take a look at Ken's functions and try figure out how it works but all I know is it does just that it works the way I expected it to.

This question is Solved thank you.