make a suitable layout for a competition in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2282298%22%20slang%3D%22en-US%22%3Emake%20a%20suitable%20layout%20for%20a%20competition%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282298%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20a%20rather%20big%20event%20with%20players%20form%20different%20countries%20and%20quite%20a%20huge%20range%20in%20level%20I%20would%20like%20to%20make%20a%20layout%20of%20the%20competion%20in%20which%20about%20100%20competitors%20are%20divided%20more%20or%20less%20according%20the%20following.%3C%2FP%3E%3CP%3EThe%20members%2Fcompetiors%20are%20from%20diffferent%20nationality%2C%20they%20have%20a%20different%20level%2C%26nbsp%3B%20etc.%3C%2FP%3E%3CP%3EIn%20each%20group%20there%20should%20be%20e.g.%20no%20four%20or%20more%20members%20with%20the%20same%20nationality%2C%20each%20group%20should%20have%20at%20least%20one%20or%20more%20very%20strong%2C%20and%20one%20ore%20more%20quite%20weak%20players.%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20in%20Excel%20to%20do%20this%20and%20if%20so%3A%20how%3F%3C%2FP%3E%3CP%3EThx%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2282298%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282361%22%20slang%3D%22en-US%22%3ERe%3A%20make%20a%20suitable%20layout%20for%20a%20competition%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282361%22%20slang%3D%22en-US%22%3EIf%20I%20can%20recommend%2C%20go%20ahead%20and%20draft%20whatever%20you%20want.%20Otherwise%20there%20is%20no%20point%20in%20investing%20time%20that%20could%20probably%20be%20in%20the%20wrong%20place%20again.%3CBR%20%2F%3EKnowing%20the%20Excel%20version%20and%20the%20operating%20system%20can%20only%20be%20an%20advantage.%3CBR%20%2F%3E%3CBR%20%2F%3EWish%20you%20continued%20fun%20with%20Excel%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%3CBR%20%2F%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282354%22%20slang%3D%22en-US%22%3ERe%3A%20make%20a%20suitable%20layout%20for%20a%20competition%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282354%22%20slang%3D%22en-US%22%3Ethx%2C%20but%20this%20is%20not%20what%20I%20meant%3A%20i%20want%20to%20classify%20groups%20in%20Excel.%3CBR%20%2F%3EExcel%20should%20create%20the%20classification%3A%20each%20group%20should%20e.g.%20contain%20max%203%20English%20pairs%2C%20two%20pairs%20with%20a%20certain%20ranking%20etc.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282326%22%20slang%3D%22en-US%22%3ERe%3A%20make%20a%20suitable%20layout%20for%20a%20competition%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282326%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1034674%22%20target%3D%22_blank%22%3E%40bozbeertje%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH1%20id%3D%22toc-hId-1304067766%22%20id%3D%22toc-hId-1304129145%22%3E%3CA%20href%3D%22https%3A%2F%2Fexcel-example.com%2Ftemplates%2Fsport-tournament-template%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ESport%20tournament%20template%3C%2FA%3E%3C%2FH1%3E%3CP%3EThere%20are%20many%20variants%20of%20tournament%3A%203%20%E2%80%93%2016%20teams%20in%20each%20group.%20The%20number%20of%20groups%20is%20not%20limited.%3C%2FP%3E%3CP%3EEach%20group%20is%20on%20a%20separate%20sheet.%20It%20contains%20a%20list%20of%20teams%2C%20the%20schedule%20and%20it%20automatically%20generates%20the%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftemplates.office.com%2Fen-us%2Fplanners-and-trackers%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EAdditional%20infos%3A%20Planners%20and%20trackers%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

For a rather big event with players form different countries and quite a huge range in level I would like to make a layout of the competion in which about 100 competitors are divided more or less according the following.

The members/competiors are from diffferent nationality, they have a different level,  etc.

In each group there should be e.g. no four or more members with the same nationality, each group should have at least one or more very strong, and one ore more quite weak players.

Is there a way in Excel to do this and if so: how?

Thx

3 Replies

@bozbeertje 

 

Sport tournament template

There are many variants of tournament: 3 – 16 teams in each group. The number of groups is not limited.

Each group is on a separate sheet. It contains a list of teams, the schedule and it automatically generates the table.

 

Additional infos: Planners and trackers

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

 

 

thx, but this is not what I meant: i want to classify groups in Excel.
Excel should create the classification: each group should e.g. contain max 3 English pairs, two pairs with a certain ranking etc.
If I can recommend, go ahead and draft whatever you want. Otherwise there is no point in investing time that could probably be in the wrong place again.
Knowing the Excel version and the operating system can only be an advantage.

Wish you continued fun with Excel

Nikolino
I know I don't know anything (Socrates)