I can use randbetween to generate a random number between 1 and 12, which I guess could work as wellhowever they need to be random and unique across 4 columns. In other words: The header column is: (- signifying new column) Name - Month 1 - Month 2 - Month 3 - Month 4.

Here's an example of nesting SEQUENCE with INT and RAND to create a 5 row by 6 column array with a random set of increasing integers. Our formula is: =SEQUENCE (5,6,INT (RAND ()*100),INT (RAND ()*100)). In addition, you could use =SEQUENCE (5,1,1001,1000) to create the sequential list of GL Code numbers in the examples.

Step 5. This will change the input type to “Date”. Step 6. Select starting and end date to generate the random data. By clicking on the drop-down arrow as shown in below image. Step 7. Select both dates and click on OK . Step 8. This will display a random date from the specified range to the worksheet. At the core of this solution is the RAND function, which is used to generate a random number in a helper column (column C in the example). To assign a full set of random values in one step, select the range C5:C16, and type =RAND() in the formula bar. Then use the shortcut control + enter to enter the formula in all cells at once.
To create the first name data we’ll use the pwrRbANDOMNAME function. These will either be male or female as designated by the data in column E (Gender). In cell B2, enter the following: =pwrRANDOMNAME ("first", [@Gender]) This will insert a random first name suited to the gender from the Gender column.
. 418 9 122 395 368 228 117 306

generate random names in excel