ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   league table (https://www.excelbanter.com/excel-worksheet-functions/159271-league-table.html)

[email protected]

league table
 
I am running a fantasy soccer league and have set up that when I insert
players points it updates the team sheets... easy enough. I now want to
create a league table which updates the teams position as points are added,
moving them up or down.

I only want the league to go on the total points scored by the team. There
is no goals scored or conceeded etc that needs calculating.

Bob Phillips

league table
 
Take a look at http://www.xldynamic.com/source/xld.LeagueTable.html, shows
how to do it.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"
wrote in message
...
I am running a fantasy soccer league and have set up that when I insert
players points it updates the team sheets... easy enough. I now want to
create a league table which updates the teams position as points are
added,
moving them up or down.

I only want the league to go on the total points scored by the team. There
is no goals scored or conceeded etc that needs calculating.




[email protected]

league table
 
Thank you Bob for the response.

I have seen the information that you sent me but it all seemed a little
confusing as I am not doing, home and away fixtures, goals for or against.

I have 10 teams that get x points which gets added up from their players. I
want a league table made up from this one lot of data. I wont it to look like
this:-

Team B Mr w 233
Team C Mr E 199
Team A Mr T 181
Team F Mr S 160
etc
etc
etc

If I knew how I would pay for someone to complete the job for me. Its
driving me nuts... Hehe

Cheers

"Bob Phillips" wrote:

Take a look at http://www.xldynamic.com/source/xld.LeagueTable.html, shows
how to do it.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"
wrote in message
...
I am running a fantasy soccer league and have set up that when I insert
players points it updates the team sheets... easy enough. I now want to
create a league table which updates the teams position as points are
added,
moving them up or down.

I only want the league to go on the total points scored by the team. There
is no goals scored or conceeded etc that needs calculating.






All times are GMT +1. The time now is 12:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com