Football Tourament Spreadsheet - Sorting a table automatically.

[Hardip]

Hello

I've offered to do a spreadheet for a charity football tourament. There are
16 teams, 4 tables. I've done the following:

1. Created a schedule of games for all teams were the score is populated
2. This then updates the tables based on a win (3 points), a draw (1 point),
a loss (0 points).

It's working well but I spotted that the table is static. As the four teams
accumlate points over the games (e.g. in Table A), the team with the most
points at that stage should be at the top of the table. This changeable and
therefore I need a method to dynamically sort the table as the results are
inputed.

At present the third team in Table A stays third regardless of the points.
I therefore need a dynamic method to sort the table on points as each teams
score is populated. I could do this manually, but I'll be playing (badly)
and also helping elsewhere. The score keeper has no spreadsheet skills and is
just about OK with populating the individual scores - but I don't want her to
keep sorting because she might make an unforeseen error.

Can the 'sort' be done dynamically? I hope that made sense!

I'd appreciate any thoughts or guidance.

Thanks to all who reply,
Hardip

 

[Bob Phillips]

The 'usual' way is to have a hidden table of vanilla results, and then have
a display table to show the sorted results, The hidden table would have a
rank column, and the display table would just lookup the associated values
corresponding to the ranks,

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Hardip]

Hi Bob

Thanks for responding. Can you please clarify what you mean as it sounds
like something I can do with a little more information.

Many (many) thanks,
Hardip

 

[Bob Phillips]

Give me a half-hour, and I will post an example.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[excelnewbieian]

Bob has just helped me out doing something very similar...

My finished version of the English Football Conference Table for th
forthcuming season is a
http://www.unofficiallyfleet.com/Conference Table.xls.

The table I will use is the one in the top left hand side. By the way
have to enter each score twice... mostley because that was the only wa
I knew yesturday before I started researching into excel!

If this is of any use to use to you please feel free to use it!

Ian

 

[Bob Phillips]

Here is an example of what I mean http://cjoint.com/?ilqRIPTZ41

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Pete_UK]

Are you an Arsenal supporter, then, Bob? <g>

Pete

 

[Bob Phillips]

Well I'm certainly not a Chelsea fan <G>

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)