Solved: How to create a "Live" points table

[Aussiebear]

I've been fooling around with a phantom competition where 5 teams play a weekly competition. I have designed a table which shows the draw, and allows for the results to be entered into it. What I'm now chasing is a method that I can apply to make the Competition Points table 'live".

By "live" I mean that as you enter in each weeks results the table updates itself by adjusting the ranking of each team based initially on the points gained and then by the differential of the points scored for the team and the points scored against the team.

That is to say , that if two or more teams are locked on the same number of competition points, their ranking is then adjusted by examing their total points scored for and the total points scored against for the season.

This project is not urgent in any way, more of just fooling around with Excel.

[Erdin? E. Ka]

Hi Aussiebear,

Check the Attached sample.

[Aussiebear]

Not bad, but it doesn't show those rounds where the fifth team has a bye. The bye also gains them points

[mdmackillop]

Hi Ted,
For a methodology consider using something like this for sorting.
Total = Comp Points + (For-Against)/100

There are quite a few such tables on the web. Worth looking at some to get ideas as to what can be achieved, and then trying to figure out the necessary code.

[Bob Phillips]

See http://www.xldynamic.com/source/xld.LeagueTable.html

[Aussiebear]

Thanks MD. I'll have a look about for these tables

[Aussiebear]

Bob, that's pretty impressive stuff that you have there.

[Erdin? E. Ka]

I edited the file,

[Aussiebear]

How do I refresh the pivot table?

[Erdin? E. Ka]

Just one click to Fenerbah?e SK's logo picture.

There is a VBA code for refresh and sorting the PivotTable.


Or

Right Click on the PivotTable and click "Refresh" option. And then sort the PivotTable.

[Aussiebear]

Thank you.

[Erdin? E. Ka]

Not at all.