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))
I hope I'm reading this request correctly. The issue is how to deal with ties in the scores?
You could use FILTER, for example:
=LET(leader, MIN(Score), FILTER(Player, Score = leader))
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?
