google-sheets

This week I got a task to randomly generate pairs based on a name list. After googling on the internet, I found a perfect solution to achieve my goal. Here are the detailed steps to achieve a random pair of two, and it’s easy to adjust to your specific needs. All the example data and formula can be found in this Google Sheet: Random Pairs . Steps Step 1 - Generate random numbers using RAND() Firstly, we need to generate a random number against each name, we can use the RAND() function to achieve that....