+ Reply to Thread
Results 1 to 4 of 4

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

  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

  2. #2
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Smile Re: How to "sort" league tables automatically based on changing forecasts

    Hi
    Take a look at attached. I obtained this formula from DO...
    Attached Files Attached Files
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, ?Born in USSR?
    Vusal M Dadashev

    Baku, Azerbaijan

  3. #3
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

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

    Here's a VBa way also

    Please Login or Register  to view this content.

    See attached file
    Attached Files Attached Files
    Last edited by Marcol; 05-08-2010 at 07:38 AM. Reason: Forgot Code tags!

  4. #4
    Forum Contributor
    Join Date
    09-17-2009
    Location
    Torquay, England
    MS-Off Ver
    Excel 2013
    Posts
    253

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

    Thanks that is great. Didnt know anything about the Large function!

+ Reply to Thread

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