+ Reply to Thread
Results 1 to 1 of 1

Automatically calculating a league table based on data from a spreadsheet?

  1. #1
    Registered User
    Join Date
    11-27-2009
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    11

    Question Automatically calculating a league table based on data from a spreadsheet?

    I have a spreadsheet for calculating the number of correct predictions of football matches, I also have a spreadsheet for a league table which displays the position of participants.

    At the moment I write down the correct number of predictions for each person and then I enter it into a league table.

    Would there be anyway of linking the data from the prediction spreadsheet to the league table, so that the league table is calculated automatically? I assume that I will need to copy the league table into the same spreadsheet as the predictions but in a new sheet.

    When editing the league table, I cut and paste the "Total Points" into the "Previous Total Points" and then enter in each Gameweek point for each person and using a simple addition formula the "Total Points" are calculated. I then use the sort tool on the "Total Points" so that the points and people are listed from highest rank to lowest rank. I then copy and paste "Position" data into the correct column so that when the league table is printed or uploaded online the only columns A-F are visible.
    Attached Files Attached Files

+ 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