Using Excel to Randomly Pair Up People for a Tournament
- Create a list of all the people who will be participating in the tournament.
- Create two columns next to the list of people. In the first column, enter the names of the people again. In the second column, enter a random number for each person using the RAND() function.
- Sort the list by the second column (the one with the random numbers).
- Pair up the people in the first column by taking every two adjacent names in the list. You can do this manually or use a formula like "=A1&"-"&A2" in a third column to automatically create pairs.
Good luck with your event!
Answer: How do I get Random pairings in Excel?
Similar Threads
Threaded Mode
