-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
golfers
-
G
20 golfers over 3 days playing in foursomes
I'm trying to create a spreadsheet where I can 20 golfers playing over 3 days and none of the golfers play with each other twice. On each team will be two "A" players and two "B" players. I've figured out how to make the 1st day random but I can't figure out out to make days 2 & 3 where the...- golfnut111
- Thread
- days figure golfers play players
- Replies: 13
- Forum: Excel Questions
-
G
randomly group golfer into teams of 4 with no repeats over 3 days
I've created a spreadsheet where I have a list of 24 golfers. These golfers have 12 "A" players and 12 "B" players. When I hit the sort button, they are randomly divided into 6 teams of 4 with 2 "A" players and 2 "B" players on each team. Now I want to do this for 3 days with no one golfer...- golfnut1
- Thread
- days golfer golfers players team
- Replies: 4
- Forum: Excel Questions
-
L
Golf 4somes
I have 160 golfers. All the golfers have handicaps. 90% of the golfers are spouses. The handicaps for a 9 hole course vary from 3 to 18. I want to be able to keep the couples together and be able to automatically build 40 teams of 4somes so that the total handicap of each 4some is as close as...- Lowggy
- Thread
- 4somes couples fudged golfers handicaps
- Replies: 4
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
