I've searched the forums and found nothing similar to my problem.
I have a spreadsheet that I'm creating for a golfing friend and I have this scenario:
There are just over 100 golfers that will play every Monday in the month of November 2015 . Each cell in the column next to the golfer's names has a drop down box with the available tee times. I need a way to limit the tee times so that each time is used a maximum of 4 times -- a foursome of players. After that limit has been reached the time should not appear as an option in the drop down list.
I've seen a similar sheet but it was based on the number of uses in a row, not in a column like my problem.
Could someone please offer me direction with this?
Attached is a portion of the sheet. Only the Nov 2 column has been configured with the drop down box.
Thank you. Any help with this is greatly appreciated.
Bookmarks