[Solved] Interactive quiz scoreboard

[wayrus]

Hi I have created a quiz scoreboard for 20 teams that updates automatically after each of the 10 rounds of questions after I enter the points scored. I can get it to rank the scores from the highest to the lowest in each round BUT I cant work out how to get the appropriate team name to appear automatically next to the ranked score. Can anyone help please Many thanks

[robleyd]

Without knowing how your spreadsheet is designed, it isn't possible to answer your question. Please upload a sample of your document.

[Forum] How to attach a document here Note maximum file size is 128K. If your file is larger, use a file sharing site such as Mediafire and post the link here. The link also contains information on how to anonymise your document if it contains confidential information.

[wayrus]

Many thanks for the quick response. Its not so much I am having a problem more I need someone to tell me what to do. I just want the team name to appear next to the rank column so that it is adjacent to the relevant score after each round. This is a link to the scoreboard as it stands. I apologise for my lack of knowledge and would appreciate any help you can give even if its just the code to put in the team name column.
https://1drv.ms/x/s!AhFsy33g4_l3zFB8CfGnJvbrLFAv

[John_Ha]

1. Delete the green columns
2. Add a TOTAL column to the right.
3. Highlight B3 .. M22
4. Data > Sort > Column M > Descending
5. Repeat Steps 3 and 4 after each round. Or record a macro to do it and place the macro on the Toolbar - it's then just one click. See the tutorial on How to record a macro. See what Data > Define Range ..., does.

You will find much useful information in the User Guides, the Writer, Base and Calc Tutorials and the AOO Frequently Asked Questions. May I suggest you bookmark the pages.

Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.

[wayrus]

PROBLEM SOLVED Wow thank you so much for your incredibly quick and detailed response. I shall follow your advice to the letter. Many thanks