Forum Discussion
Golf Teams
I have a sheet with 40 golfers. Each golfer has a rank (A,B,C or D) based on handicap. The sheet has 3 columns (First, Last, Rank). I need a formula to pick 4-player teams randomly (but only pick ...
Sorting each handicap by a set of random numbers would allow you to generate teams. Bear in mind, however, that RANDARRAY is volatile and you will get a new grouping every time you open or alter the workbook. To stabilise a given selection you would need to manually copy the team lists and paste them as values.