Auto Sort League Table

Hi

This is my first post on here so I'm really hoping that someone can help me as soon as possible please, as I need to have this file sent out by tomorrrow!!

I have created a file to organise my friends/colleagues score predictions for the European Championships tomorrow. Points are automatically calculated when the actual scores are entered into another tab. I now need to know how to make the 'Leaderboard' tab automatically sort, based on the rank.

The data is organised as follows:

Column A: =Rank(Col C)
Column B: Name
Column C:=Score (calculated from other tabs)

Is this enough information? Can't seem to be able to upload the file for some reason.

Thanks in advance
Adam

It's difficult to recommend anything without seeing your workbook.

However, you can download a free workbook for Euro 2012 from here:

http://www.thecodecage.com/forumz/mi...mpionship.html

which might be quicker than trying to get your own to work.

Hope this helps.

Pete

Originally Posted by Marcol

Use a helper column to tie-break the results
i.e. Points + (Gosl Diff/10^3) + (Goals For/10^6)

Then sort on that column or use INDEX()/Match() as in this workbook.

Say that you set all your teams to played 1 game, all draw and no scoring. Then this table(and formula) only project the first team in the table. How can you fix that?

Skjermbilde 2012-06-09 kl. 09.15.45.jpg

Thank you very much for the answere. I really appreciat it.