Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Matt Porter
 
Posts: n/a
Default Updating a league table

Hi guys. I'm trying to teach myself to use excel and as a project to get me
going I've decided to create a results and league table for the English
Football Premier League.

I've got my fixtures and result grid, and the league table. I've programmed
the league table to update the win, lose, draw, goal difference for both
home and away
fixtures and the total points for the team automatically when I type in the
results. However I can't get it to automatically sort the league table by
order of points
(highest to lowest) and to take into account the superior goal difference if
points are tied.

If anybody has any thoughts that could help me, I would appreciate it, but
please take into account that I am just starting to learn excel so you may
need to dumb things down for me to understand. I can e-mail to document to
any of you if it helps you to get a clearer picture of what I need.

Many thanks
Matt



  #2   Report Post  
MBlake
 
Posts: n/a
Default

Hi,
Visit this link and download the example league table -
http://www.xldynamic.com/source/xld.LeagueTable.html

Regards,
Mickey


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating a league table. Matt Porter Excel Worksheet Functions 0 May 9th 05 06:41 PM
League Table kathleen.smith10 Excel Worksheet Functions 2 March 28th 05 01:00 PM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 07:24 PM
Can I setup a league table that automatically updates itself? sd8974 Excel Discussion (Misc queries) 0 February 4th 05 01:15 PM
table dow Excel Worksheet Functions 0 January 11th 05 05:17 PM


All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"