footie prediction league table-help required please

I use a sheet I've created for a footie prediction comp(this is very basic ,simple sum feature to calculate total scores-I'm a novice at this !!)

I input the weekly scores in Columns L to BA ,and the SUM feature in column I gives the total score for each person



I need the copy of my main sheet attached ,amended ,so that when I type in the new weekly scores,it does the following,automatically,:


Sorts players into total points order highest to lowest (it totals the points already)
Inserts league position for each player
Inserts movement icon (up,down,no change) for each player ,compared to the previous week�s position

I currently do this manually which is a pain

Any help would be greatly appreciated !!

Cheers Bruce !!

It would be interesting if you inform your version of Excel so that I can provide the correct answer.

The solution I'm giving to you is mostly for Excel 365.

Column B is with your arrows formatted to change color according to the formula bellows:

Formula:

Please Login or Register  to view this content.

Column K there is another set of arrows that you could use from Conditional Format, it will follow the result of the formula bellow:

Formula:

Please Login or Register  to view this content.

Column D automatically bring the last result from your matrix:

Formula:

Please Login or Register  to view this content.

Column A automatically form a rank, this rank follow Excel formula rule for rank:

Formula:

Please Login or Register  to view this content.

Please update your profile to reflect you Excel version.

Join Date: 09-02-2007
Location: Rochester,England
MS-Off Ver: Excel 365 v2312
Posts: 13

The easiest way to sort everything is to extend the filter from A to BA as I did in the file attached.

Please add your Excel version to your forum profile, as you have been advised to do already.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.