First off, I'm a novice at excel.
I need some help. I work at a golf course.
At work, I need to randomly pair players together to form teams.
For example:
Saturday morning, there are 19 golfers signed up to play together, but want to paired randomly.
This is what we currently do:
In cells A1:A27 I type their names. In B1:B27, I type their handicaps.
We then use a deck of cards to randomly draw teams. We do this by pulling 4-A's, 4-k's, 4-Q's, 4-J's, and 3-10's from the deck. We shuffle these cards and then go down the names in colum A and assign each palyer a card and place the card value into column C. We then highlight all three columns and sort by column C to form teams.
This works ok, but the problem is they all tee off at the same time and need a "super quick" process to form teams in seconds.
The only variable that I might see being a problem is the # of players vary each time they play. There might be 12 one day and 51 the next. We have to form teams into 4 somes and 3 somes, based on the total number of players we get.
Any help appreciated... The easier the better!! Thanks!
I need some help. I work at a golf course.
At work, I need to randomly pair players together to form teams.
For example:
Saturday morning, there are 19 golfers signed up to play together, but want to paired randomly.
This is what we currently do:
In cells A1:A27 I type their names. In B1:B27, I type their handicaps.
We then use a deck of cards to randomly draw teams. We do this by pulling 4-A's, 4-k's, 4-Q's, 4-J's, and 3-10's from the deck. We shuffle these cards and then go down the names in colum A and assign each palyer a card and place the card value into column C. We then highlight all three columns and sort by column C to form teams.
This works ok, but the problem is they all tee off at the same time and need a "super quick" process to form teams in seconds.
The only variable that I might see being a problem is the # of players vary each time they play. There might be 12 one day and 51 the next. We have to form teams into 4 somes and 3 somes, based on the total number of players we get.
Any help appreciated... The easier the better!! Thanks!