Golf Tournament Spreadsheet

Hi,

I am in charge of running and organizing golf tournaments and I was wondering if someone could help me figure out how to make my life easier with excel. The main thing that I have to do is create the Tournament Draw and Alpha list based on a list of names.

I have attached a file below and I was wondering how I can easily get all the names from the player list into the Draw list but at random. So all these names would be mixed up in groups of four.

Once that is complete I need all these names sorted on an Alpha list by last name and also include what group they are in.

I'm sure there is an easier way of doing this without just copying and pasting.

Practice Tournament Draw.xlsx

Thanks.

Thanks a lot, it seems to be working pretty good. The only problem is there is always one row where D=0 and this always happens when C = 137. Why is that?

Originally Posted by alansidman

I am unable to replicate this issue. Attached is your file with my formulas as shown in the post.

Awesome! Thanks! Would it be possible to sort theses names by last name in the Alpha sheet with the way the names are formatted?? (ex. F. Pelletier)
Or does the F. at the start make that not possible?

Thanks! Just one last question. Lets say I had another tournament with only 80 Golfers. I'm guessing I would need to switch the bolded number to 80. Is there an easy way to do this for every cell quickly. Im basically just trying to make a template for every tournament


=RANK(B1,$B$1:$B$144,1)+COUNTIF($B1:$B$1,B1)-1

Thanks you so much for your help. This might be harder to create then I first thought. I was hoping to just have a template I can use for every tournament and just plug in the names and be done. The problem is some tournaments have less people which means their might only be 3 people in a group or 4 in some and 3 in others. Some might also involve teams so their might be two people that have to be together.

The attached file is another possible solution to the tournament spread sheet. just found the post and this may be a little late.
The code does not use any VBA. The info sheet has some info for the formulas. I use EXCEL for score cards and scoring for my Golf Buddies.
The odd number of players is a more difficult problem and this code won't handle that
Hit 'em straight
IT IS ALL PURPLE SMOKE & MIRRORS,