Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a Special Sort Routine
Hi there,
Colums A and B are participant combinations (round-robin - 6 participants), I would like to sort these two columns and come up with a schedule knowing that I have 2 ping-pong tables available for the Round-Robin. I would like to apply this routine to any number of participant matchups (i.e 16 participants and in that case I could have only 5 tables available.) I just need to make sure that for every 5 first combinations none of the existing players are double booked. A B --- ---- 1 2 1 3 1 4 1 5 1 6 2 3 2 4 2 5 2 6 3 4 3 5 3 6 4 5 4 6 5 6 Thanks, w |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort Routine | Excel Discussion (Misc queries) | |||
Special Sort Help | Excel Discussion (Misc queries) | |||
3 level sort, last special order | Excel Worksheet Functions | |||
Sort Routine VBA | Excel Programming | |||
Excel - special sort | Excel Programming |