Squash Ladder Spreadsheet

[Ian2802]

Hi there,

Does anyone have a spreadsheet to allow a squash league table to b
automated....

Thanks,

Ia

 

[Da Cavesta]

This may be useful.

Cheers,

Chris

+----------------------------------------------------------------
| Attachment filename: ladder.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=373449
+----------------------------------------------------------------

 

[Ian2802]

Cheers Mate,

Thats what i was after...

Do you have anything to sort the 'ladder' as such? We are playin
whereby you can only 'challenge' a person up to 2 spaces above you i
the ladder....

 

[Da Cavesta]

Try this version.

Cheers,

Chris

+----------------------------------------------------------------
| Attachment filename: ladder v2.0.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=373582
+----------------------------------------------------------------

 

[Ian2802]

Cheers Mate,

One further request.... If someone challenges someone 2 places above
them

Pos Name
1 a
2 b
3 c

then the spreadsheet results in...

Pos Name
1 b
2 c
3 a

BUT, i'd like it to be.....

Pos Name
1 c
2 a
3 b

Thanks again....

 

[Ian2802]

Chris...

Do you anything that simply swaps the winner and the loser over, rathe
than shuffling everyone else around....

Ia