VBA or Formula needed for Leadeboard / Games Round Creator - Help required please

Ravenous

New Member
Joined
Jun 5, 2018
Messages
1
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.

576393d1528084508-vba-or-formula-needed-for-leadeboard-games-round-creator-help-required-please-capture.png


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
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,223,227
Messages
6,170,849
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top