How do I get Random pairings in Excel?

[bchappell]

I need to match up people randomly for a tournament. Can I use Excel to do
this?

 

[James Silverton]

bchappell wrote on Mon, 4 Feb 2008 08:11:02 -0800:

b> I need to match up people randomly for a tournament. Can I
b> use Excel to do this?

Would assigning a random number to each and then sorting on the
random numbers work?

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

 

[Gary''s Student]

Say we have 50 people. Put their names in column A in A1 thru A50
In B1 thru B50 enter:
=RAND()
Sort columns A & B by column B

Pair A1 & A2
........A3 & A4
........A5 & A6
..
..
..
etc.

 

[bchappell]

I tried that. The only problems was I ended up with 2 people with the same
random number. Maybe I did it incorrectly?

 

[bchappell]

I will try this.

Say we have 50 people. Put their names in column A in A1 thru A50
In B1 thru B50 enter:
=RAND()
Sort columns A & B by column B

Pair A1 & A2
.......A3 & A4
.......A5 & A6
.
.
.
etc.

 

[bchappell]

I figured it out. I didn't sort correctly. I have it working now.

Thanks all for the help!

 

[James Silverton]

message

I tried that. The only problems was I ended up with 2 people
with the same
random number. Maybe I did it incorrectly?

Even if you did get two people with the same number, it wouldn't
matter after sorting! Tho' they would appear sequentially in the
sorted list they migh or might not be paired.

 

[Barani Parthiban]

Hi all...

I have to randomly arrange the colours on excel...

Could you please help me?

Example:

Colours:Red, green, yellow, orange

Task:

1)Red green
2)Red yellow
3)red orange
4) green yellow
5)green orange
6)yellow orange

...

But it shouldn't overlap with same colours