Create Random Pairs in Excel & Google Sheets

This week, I got this task to randomly generate pairs based on a name list. After googling on the internet, I found a perfect solution to achieve this. Here are the detailed steps to achieve a random pair of two. All the example data and formula can be found in this Google Sheet Random Pairs. Step 1 - Generate random numbers using RAND() Step 2 - Copy the random number values to a new column named Value Excel or Google Sheets will automatic re-generate a new series of random numbers with the RAND() function....

November 16, 2022 · 1 min · 212 words · Eric