Creating a leauge table

[andypw1981]

Hi all

I'm doing a dream team for all the guys at work for Euro 2004.

I have set up a spreadsheet working out all the players scores etc. I'
just wondering how I could go about creating a sort of 'League table
based on each person's scores, in the usual format of highest score a
the top - lowest at the bottom. I want it to work out the positions i
the chart accordingly to the updated scores.

Any help or advice would be very grateful.

Thank you all in advance.

And

 

[Bob Phillips]

Andy,

There is an example at
www.xldynamic.com/source/xld.LeagueTable.html
Maintaining A League Table

that whilst I don't think is exactly what you want (yours is a type of
fantasy football league?), it may give you some hints.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Dennis]

If you can download the results to a sheet then you could use Lookup for
each player and a sum for each team. A Table could have these (Sum) values
against each Manager's name and a sort could be done manually or thru'
macro. I could send you my Excel Fantasy Cricket Wb which shows my managers
weekly totals, season totals, weekly positions and win/loss on the
week/season (£1 per week). All you have to do is copy & paste the weekly
result from the Web and run a macro. This would have to be modified
according to your number of managers...but you could get the idea.