8 team Golf Schedule - need formula to choose teams

[NorthCountryVinyl]

Hi all.

Newbie here, I'm trying to figure out a formula to randomly choose team matchups for an 8 team golf league. And...I'm completely drawing a blank. Can anyone help me?

Thank you!
Sandi

 

[tyija1995]

So you want to randomly choose 8 teams?

In A1:A8 use the formula =RAND()
In B1 use the formula =RANK(A1,$A$1:$A$8) and drag it down to B8.

That will generate random unique numbers in column B between 1 & 8. That can then be assigned to a team, e.g. 5 = "golf star players"

 

[Special-K99]

Type the names of the teams into A1:A8

in B1:B8
=RAND()

in C1:C8
=INDEX(A$1:A$8,MATCH(SMALL(B$1:B$8,ROW()),B$1:B$8,0))

Row C will pick a random team from your list of 8 without duplicating it.

Each time you do a calculation however a new selection of the 8 teams will be made.

 

[Special-K99]

So you want to randomly choose 8 teams?

In A1:A8 use the formula =RAND()
In B1 use the formula =RANK(A1,$A$1:$A$8) and drag it down to B8.

That will generate random unique numbers in column B between 1 & 8. That can then be assigned to a team, e.g. 5 = "golf star players"

That's a nice alternative!

 

[NorthCountryVinyl]

Thank you SOOO much!

 

[NorthCountryVinyl]

Thank you SOO much!

 

[NorthCountryVinyl]

Wait, when I use the =INDEX... I think it might be duplicating. ? Or maybe I've done something wrong.

-- image removed --

 

[Special-K99]

My formula should be OK, used it several times.

 

[NorthCountryVinyl]

Okay, thank you. I'll double check, I must've typed something wrong.

 

[AhoyNC]

This web site may be of help.

http://golfsoftware.com/tools/schedule/golf-pairings-generator.html