Dynamic Sort or One Click Sort

This is a leader board I came up with for my chess club. Is it possible to have a dynamic sort on Grand Total (without disturbing SN column), or alternatively a SORT button to be clicked after completing entries for a round? I don't want to use filters nor the Data Sort because I want it to be user friendly.

You can use this formula in cell CG11:

=RANK(CE11,$CE$11:$CE$24)+COUNTIF(CE$11:CE11,CE11)-1

and copy down to CG24. It will give you the appropriate ranking of the totals in column CE, with highest at number 1. Then you can show the names in that order using this formula in CH11:

=INDEX($L$11:$L$24,MATCH(ROWS($1:1),$CG$11:$CG$24,0))&""

Copy this down to CH24. The names in column L (and their associated data) do not get moved, so you can put this leader board anywhere in your sheet (or even on another sheet entirely).

Hope this helps.

Pete

Oh okay, thank you very much, this worked

Glad to help. If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

You could improve some other formulas too.
They are highlighted in green in the file attached.

Formula:

Please Login or Register  to view this content.