Results 1 to 3 of 3

Weekly Rating System

Threaded View

  1. #1
    Registered User
    Join Date
    11-12-2012
    Location
    sf, ca
    MS-Off Ver
    Excel 2003
    Posts
    2

    Weekly Rating System

    I am trying to do the following.

    A2:A11 are a ten point system.
    A2 is first place - ten points, A3 is second place - nine points.. and so on

    A1:E1 are the five weeks I need rated.

    B2:E11 are different names. We can use sports teams. They vary every week.

    At F2 I would like to be able to find a said sports team, and accumulate it points and rank it.
    So if the Giants are in first place every week, except the last week, they should have 49 points (4 first place ten points, 1 second place 9 point)
    I would like for them to show up first in the rankings list with their total points.

    Can someone guide the way please?
    Last edited by swltony; 11-12-2012 at 04:12 PM.

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