July 2015

Sun Mon Tue Wed Thu Fri Sat
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31  

First Division Club Maps

« A preview of the 2011-12 CCL group stage: Groups C and D | Main | Belize gets the all clear from FIFA »

August 16, 2011

Comments

D

>

Don't need a macro, just use the Rank formula for your unsorted table based upon points and tie-breakers. Then create another table where it auto-ranks by vlookup or match/offset formulas to look for the appropriately ranked team.

I've used this method for my leagues and it works well. Let me know if you are interested in seeing it and I'll email it through.

Thanks and I enjoy the blog.

The comments to this entry are closed.

HexagonalBlog on Twitter

Blog powered by Typepad

Tracker