hi, i'm trying to create a football league table for my own use. what i wanna sort is the cell containing points, when ever the cell's value changed it will automatically sort in by largest number to smallest number. pls help me with this...?

The simplest thing would be is to record a marco and run the macro via a command button. So that when the table is updated you run the macro and it sorts out the league positions of the football teams.

ps remember using a simple sort largest number to smallest number might not give you the results you want. For example what if two teams are equal on points, then if you want to factor in goal difference or most games won.

i'm sry i dunno how to put marco to it... if i attach the file there could u pls help me out with that? if possible i wish the cell (RANK) could remind same, it wont change the value inside when the sorting is done?

here you go, I have created a command button based on Rank and Points.

If you do a simple search within excel it will show you how you can record a simple macro. You dont have to have any programming skills, and can be useful to automate tasks.

hi ESA Informatics, hmmm u said "here you go, I have created a command button based on Rank and Points." u forget to attach the file? :D