Hi,
I have attached forecasting tool which I am working on for the world cup for the sake of practicing Excel.
The user enters the forecast result (W / L / D) in the column highlighted in yellow. This then gives a point score.
Currently using SUMIF I am totalling scores next to team names, but I would like to be able to then sort this automatically, ie if I change a forecast so that a team scores more or less, it moves up or down the table accordingly without the need to go through the manual sorting process.
Any help would be much appreciated!
PS I am using a different computer so I am in Excel 2007
Bookmarks