Results 1 to 4 of 4

How to "sort" league tables automatically based on changing forecasts

Threaded View

Gooford How to "sort" league tables... 05-08-2010, 06:26 AM
contaminated Re: How to "sort" league... 05-08-2010, 07:10 AM
Marcol Re: How to "sort" league... 05-08-2010, 07:30 AM
Gooford Re: How to "sort" league... 05-08-2010, 08:47 AM
  1. #1
    Forum Contributor
    Join Date
    09-17-2009
    Location
    Torquay, England
    MS-Off Ver
    Excel 2013
    Posts
    253

    How to "sort" league tables automatically based on changing forecasts

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1