Hi all. I hope that I have posted my question in the correct location. I am a complete novice on excel so i hope you will be able to assist me. Since before office in the days of super calc i have been running a local pub league which consists of 48 teams divided into 4 sections. i am now running excel 2007 and the system i blundered my way through by trial and error works fine.
There has always been one thing that i have never found an answer for so i thought i would ask here to see if what i want to do is possible.
When the season is ready to start i have a list of the 48 teams in column a. in column b i have a rand sort and in column c and d i have 4 sections. i then run a macro i recorded which states randomly sort column a, copy the first 12 teams and put in section 1 ,the second 12 in section 2 third in three and last 12 in 4.this works fine but here is the problem. A lot of the pubs have more than one team, some have 2 some have 4 etc. what i would like to be able to do is not have duplicates in the same section so if a pub has 4 teams i would like excel to automatically place them in 4 different sections instead of me having to do it manually. The same goes for 2 or 3 teams from the same pub. If someone would be able to look at it for me and tell me if it is possible i would be very grateful.As this is my first post Please let me know if any more info is needed