Random Pairs

Hello,
I'm looking to create a spreadsheet that creates random pairs of people. I want to have two lists of people for example: I want to do a random coed tournament. so I have the following lists:

Men
John
Dave
Dan
Nate
Rory

Women
Britt
Paige
Kristen
Heather
Kelly

A________B_______C
TEAMS___Man___Woman
Team 1
Team 2
Team 3
Team 4
Team 5







What formula would I use to put in the cell(or cells) to create the random pair? I want it to be a simulated way of not putting names in a hat.

Thanks for any help!!!!

I like the idea of using a button, that RAND function seemed really volatile. Now, how do I edit that button? This coed tournament could have up to 30 people in it, or it could have 16...how do I easily edit the ranges if I need to? Could I set up a range of up to 40 teams and then just click the button even if I only have 5 teams? How about if I have one group of ten people that need to be paired together but I don't have them separated by gender? For Example

Dave
John
Dan
Rory
Nate
Paige
Kirsten
Kelly
Heather
Britt


A________B_______C
TEAMS___Player A___Player B
Team 1
Team 2
Team 3
Team 4
Team 5

For some reason whenever I pressed Generate it gave me a run time error (438)

To further clarify what I am looking for it is for running a two person team tournament with a random draw based on Skill level. We categorize everyone into either an A, B, or C player. An "A" Player gets matched with a "C" player and all the "B" players are thrown into a hat and matched at random.

So what I want to accomplish is to have a program that I can pull up and simply type people in as an A, B, or C player, have the A players matched randomly with the C and all the B players randomly paired. Each of these players have a score attached to them also, this only comes into effect once the team is matched up and they would get a total score which determines their ranking. I think I can do that part with some "sumif" formulas but I just want to cut out the random drawing of players that I have to do while everyone is waiting around to get the tournament started.

Thank you all so much for your patience...I really suck at explaining myself sometimes.

no attachment anymore in post number 5

There was another thread very similar to this question:

Click on this link to see if it helps.

Try again, I must have been editing when you last looked.

Thank You everyone, my problem is solved! That was very quick help, thank you to everyone who put effort into answering my question THANKS!!!!

Hi Again

If you are happy that your problem is solved.
Please mark it so don't just change the title!


Please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!