Hi All,
In a situation here! Below is a Competition Leaderboard that I am working on for a client. What he wants is for each round, each Player will compete against another based on their position on the leaderboard. For example in the below snapshot Jack played Kevin in Round 2 because they finished 1st and 2nd on the leaderboard.
The issue with this system is that it doesn’t guarantee that players do not player each other more than once. I am seeking a Formula or Macro (for the Players columns) that will pick up if a player has already played against his proposed opponent, and if so; reshuffle the order whilst ensuring that no player is up against someone they have already played.
Appreciate any assistance that anyone can give here!
Many thanks,
Brendan
In a situation here! Below is a Competition Leaderboard that I am working on for a client. What he wants is for each round, each Player will compete against another based on their position on the leaderboard. For example in the below snapshot Jack played Kevin in Round 2 because they finished 1st and 2nd on the leaderboard.
The issue with this system is that it doesn’t guarantee that players do not player each other more than once. I am seeking a Formula or Macro (for the Players columns) that will pick up if a player has already played against his proposed opponent, and if so; reshuffle the order whilst ensuring that no player is up against someone they have already played.
Appreciate any assistance that anyone can give here!
Many thanks,
Brendan