When you use RANDARRAY, you need to specify how many dates you want to generate. And this you need to specify in the terms of columns and rows. =RANDARRAY (10,2,A2,B2) In the above formula, I have specified the 10 rows and 2 columns and it has generated 20 random dates (10 x 2) in the result. Note: Both of the functions that we have used above Right-click in the formatted data and choose Get Data From Sheet. The data is loaded into the Power Query as seen below. Click on Add Column tab. Click on Custom Custom. In the formula bar, type in Email PQ as column name. In the formula. execute the following: =Text.Lower (Text.Combine ( { [Last],”.”, [First],”@yahoo.com”})) Lastly, if you need to generate the random numbers without repetition instead of using the Excel formulas, you may use the following Add-ins of Excel. To use the Add-ins, follow the steps below. ⇰ Go to File > Options. ⇰ Click on the Add-ins and select Excel Add-ins from the drop-down list and pick the option Go. Note: Group 4 only has 1 person assigned, because there are not enough names shown to fully populate group 4. Note 2: By setting the num_digits input to 0, we tell the ROUNDUP Function to round up to the nearest integer. Random Groups in Google Sheets. All of the above examples work exactly the same in Google Sheets as in Excel. What would be the easiest way to randomly create name pairs in excel? Something like secret santa. I also need to assign a random 0 or 1 to each person in every pair. They can't have the same digit. So it's either a random 0 or a random 1. Something like this Attendees: John Tom Ellen Nathan Result: John (0) & Nathan (1) Ellen (1) & Tom (0) Then just hit the ENTER button and you will get a random value like the image below. Formula Breakdown: RANDBETWEEN (1,8) It will return a random number among the numbers from 1 to 8. INDEX (B5:B12,RANDBETWEEN (1,8)) Then the INDEX function returns the corresponding value from the list according to the number. Col G to work out number of tests within last 6 months prior. Col H to create a random number for each patient. Cell A1 to pick random patient but excl those has 2 or more tests within last 6 months (<=2 in Col G) Press F9 to recalculate thus pick another patient. Book1. Let's assume the list of names is in column A, starting from cell A1. Step 2: In an empty cell where you want the random name to appear, you can start by entering the following formula: =INDEX (A1:A10, RANDBETWEEN (1, 10), 1). This formula will select a random name from the list in cells A1 to A10. Step 3: Press Enter, and the cell will display E19XM.