Golfing schedule

**Paulkri** · 03-21-2013, 03:18 PM

I am a relative novice to formula and functions in Excel and this is my first posting.
I am trying to schedule a golfing holiday for 12 people and it will consist of 4 rounds of golf over 4 days. We will be playing in 3 sets of fourballs on each day.
A draw will be made to allocate a number or letter to each player (see tab ‘List’).
On the tab ‘Order of Play’ I have a sequence that tries to maximise the opportunity of each player to play with as many of the other 11 players, and this is shown in the table headed SCHEDULE.
In this tab I also use VLOOKUP to match the number or letter allocated in the draw which is in the tab ‘list’. From this function the individuals names are entered into the table headed NAMES.
I have the produced a matrix with the intention of counting the number of times each player will play against the remaining players. What I need help with is how to populate this table using an automated formula(e). I could simply count the numbers time one player plays with the remaining players and repeat this for the other 11 players and populate the matrix manually, but if any changes are made to the schedule I would have to repeatedly manually count and populate the matrix. Spreadsheet attached.
If anyone could provide suggestions (apart from give it up!) or point me in a direction where I could l find relevant information, it would be very much appreciated.
Paulkri

**ratcat** · 03-23-2013, 09:21 AM

G'day and welcome to the forum,

Hope the attachment is helpful ?

**Paulkri** · 03-23-2013, 10:41 AM

Dear ratcat
this is purrfect! I cannot thank you enough for solving my dilemma. What a great forum.
Paulkri

**Paulkri** · 03-23-2013, 11:57 AM

Originally Posted by ratcat

G'day and welcome to the forum,

Hope the attachment is helpful ?

Have I made you happy ??? If yes, please make me happy by pressing the Reputation icon *in my post.*
Please don't forget to do the same to other contributors of this forum.

Yes I am very happy and I would gladly press the Reputation icon, but as a newcomer to the forum I am not sure how to do this or where to find it.
Paulkri

**ratcat** · 03-23-2013, 06:51 PM

G'day Paulkri,

Thanks for the thanks. Has for the Rep icon its located on the left hand corner of each post (when logged in). Click anyone of my posts.

Also can you please mark the solved. If your having problems with marking the thread, please contact a staff member and they will mark it on your behalf.