Forum Discussion
named golf players duplicated in the order of play. Used formula in each order of play
using formula :- ==@INDEX($B$5:$B$12,RANK(C6,$C$5:$C$12))
not got the correct changes Patrick.
The object is to setup 4 ball matchs from the golfers listed so they are in the teams. They Having a list of players now need to set the 4 ball groups. No scores required. Handicaps not known at the start. When checking the list I placed the players in line with a random number. This is fine, but I need to eliminate where the same golfer is mentioned twice so the spread across the 8 balls. I set this from using random numbers against the golfers across all the players. No scores mentioned
Would be obliged if you could determining the correct formula so no duplicates shown
Do you happen to have an anonymized sample workbook you can share?
