Whizz Wrote:
I'm running a fantasy football league at work and i'm updating it via
excel.
The system requires you to add points for each player in each team and
a
total is calculated. I would then like to create a league table to show
which
team is leading... it needs to update as I enter in the new points for
each
player. I know it's really simple but I can't for the life of me
remember how
to do it.

I do not know how your worksheet looks like but you might be needing
some helper columns for this.

For example, the team names may be summarily entered in Column G (from
G1 to G10, assuming you have 10 teams in your fantasy league). From H1
to H10 are entered the total scores for each corresponding team.

Based on the entries in Columns G and H, you can then RANK the teams.
Check out *www.cpearson.com/excel/rank.htm * for an excellent
explanation with sample applications regarding this topic.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=399736