How do I get Random pairings in Excel?

  • Thread starter Thread starter bchappell
  • Start date Start date
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
 
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.
 
I tried that. The only problems was I ended up with 2 people with the same
random number. Maybe I did it incorrectly?
 
I will try this.

Gary''s Student said:
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.
Click to expand...
 
I figured it out. I didn't sort correctly. I have it working now.

Thanks all for the help!
 
message
I tried that. The only problems was I ended up with 2 people
with the same
random number. Maybe I did it incorrectly?
Click to expand...
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.
 
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
 
Back
Top