Help Request (sort order)

[Bob]

Hi All,

I'm sure this has been asked a hundred times before but I've googled till
I'm blue so here goes.

I run the mini leagues for my local squash club, there are 5 players per
league and generally 10 to 12 mini leagues per season.

Each person in a league plays the others in that mini league. At the end of
each month, the top 2 players from each league go up to the next highest
league (except for league 1). The bottom 2 players in each mini league move
down a league (except for the bottom league). The people in the middle of
each league therefore remain in the same league for the next month...and so
on.

Does anybody know of or have an excel spreadsheet that would save me doing
the monthly calculations manually?

I'd really appreciate it as time is short with little ones in the house.

Many thanks in advance.
Alan
alan---at---ime[miss this bit out].co.uk

 

[marston_gould]

Here's a few ideas that might work....
1) Use the Rank function to rank the players
2) Then have a list that goes from 1 to n (the number of players)
3) Then use the = offset(column with name, match(number from 1 to n,
the rank column, 0), 0, 1 1).

In otherwords,
If you have the names in the range A1:A50, and their rating (w/l or
whatever it is you use, in B1:B50, then in C1 you would have =
rank(b1,b$1:b$50) - copy down to C50. Then in D1 you would have the
number 1, in D2 = D1+1 and so on down to D50. Then
in E1 you would have =offset($a$1,match(D1,$c$1:c$50,0)-1,0,1,1) - copy
this down to e50 - this will sort the names from top to bottom.