I have got a list of soccer teams on sheet from column c row 7 to 44, what i want is vba to pick the teams to play each other, so like this
Saudi Arabia - Brunei
there are 38 teams altogether
and so on, but random, can this be done.
I have got a list of soccer teams on sheet from column c row 7 to 44, what i want is vba to pick the teams to play each other, so like this
Saudi Arabia - Brunei
there are 38 teams altogether
and so on, but random, can this be done.
You could try the below formula you would need to create to cells Team 1 Team 2 (or similar) and apply the formula to each cell.... if you want to select another two teams press F9 - it might on occassion choose the same two teams but pressing F9 will select another.
=INDEX($C:$V,RANDBETWEEN(1,COUNTA($C:$C)),1)
Thats not what i want i want to be able to press a command button and it does a draw not picking the same teams i could post a copy of the sheet that i have done
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks