How do I get Random pairings in Excel?


B

bchappell

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

Advertisements

J

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
 
G

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.
 
B

bchappell

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

bchappell

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.
 
B

bchappell

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

Thanks all for the help!
 
Ad

Advertisements

J

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.
 
Ad

Advertisements

Joined
Jan 25, 2018
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top