Help with a live table that re-arranges itself automatically.

[Overdahill]

I'm looking to create a table that re-arranges itself based on scoring. I have managed to get so far as to adding a =RANK formula, so it does provide ranks on the table, but I would like to understand if their is a way it can automatically re-arrange the table, based on the rank number best to worst.

I hope thats understandable?

Cheers everyone!

[Limor_OP]

I think you have to have a data source that you enter manually or download from some kind of external source , and then based on that - create another table that will be re-arranged the way you want it to. A pivot table for example....

If you mean that the same table you enter the data into will re-arrange itself somehow - then I don't think it is possible...