creating a 18,16,14,12, etc person matrix

[tonylpcs@yahoo.co.uk]

Hi everyone,

im getting so stuck on this i cant see the wood from the trees!

I need a games matrix for a chess tornament.
i need to create a matrix so each player plays every other player only once, andonly one game each per day! (you cannt have one person playing two games at the same time!)

I was given a 20 player matrix that is exactly what im looking for (each player is represented by a number to keep things easy!)

but the problem is i dont know how many players there will be?

it could be a max of 20 but it could be less!

can someone help me out with showing me some code to create a matrix that is calculated on the number of players ie in cell E5, and it will give me the matrix with each player playing the other only once?

lets say the matrix starts in cell E7 and populates from there!

please help if you can

Tony

 

[sezuh]

Please see this tread Post #5 for result i hope its correct.
http://www.mrexcel.com/forum/showthread.php?t=564774

 

[tonylpcs@yahoo.co.uk]

Thank you so much

for some reason i was unable to do that so thank you.

tony

 

[West Man]

You may find this interesting http://nrich.maths.org/1443