How would I create a weekly ranking system showing position change?

**acousticsman** · 07-02-2015, 06:52 PM

How would i recreate this in excel? It is a weekly positioning table for leagues.

Table.jpg
(I dont need the formatting, i can do that myself at a later stage)

This is my data set

Week 1	Team 1	1	Team 2
Week 1	Team 3	1	Team 4
Week 2	Team 5	1	Team 6

etc etc

I'm not sure where to begin with this. I currently have a table that calculates the over all standings.

For wins I use:
=SUMPRODUCT((HomeTeams = $J3)*(ISNUMBER(GoalsFor))*(ISNUMBER(GoalsAgainst))*(GoalsFor > GoalsAgainst))
and you can deduce from this how I calculate draws, losses, goals for and against.

I have a rank function that ranks by pts, then by goal difference, home goals, away goals.

I believe what I need is something similar but multiplied by the no of weeks which is a lot! (about 274! - Don't ask! Me and my crazy experiments)

(I don't know if i could use data sets per week ... ??? If that is the case how would I automate it to run through 294 weeks?)

**FDibbins** · 07-02-2015, 06:57 PM

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you

Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.