ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   League Tables for sports events (https://www.excelbanter.com/excel-discussion-misc-queries/18062-league-tables-sports-events.html)

mje26811

League Tables for sports events
 
I am trying to find a way to "data-sort" in real time. I have a league table
set up for my football team which lists team name, games played, games won,
games drawn, games lost, goals for, goals against, goal difference, and
points awarded total. The table auto-populates with the scores I enter into a
fixtures sheet. All I would like to do is to formulate a way to get the whole
table to "data-sort" in real time, in the following order ...

Sort by points total (descending), then goal difference (descending)

Please could someone help me?

Thanks

Mike E

Bob Phillips

Take a look at http://www.xldynamic.com/source/xld.LeagueTable.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mje26811" wrote in message
...
I am trying to find a way to "data-sort" in real time. I have a league

table
set up for my football team which lists team name, games played, games

won,
games drawn, games lost, goals for, goals against, goal difference, and
points awarded total. The table auto-populates with the scores I enter

into a
fixtures sheet. All I would like to do is to formulate a way to get the

whole
table to "data-sort" in real time, in the following order ...

Sort by points total (descending), then goal difference (descending)

Please could someone help me?

Thanks

Mike E





All times are GMT +1. The time now is 01:37 PM.

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