Highlight the first cell you want to randomize, then click and hold "CTRL" to select other cells out of sequential order. To highlight an entire descending list, click the first cell, then hold "SHIFT" and click the last cell in the column or row. 2. Add a new column called "Sort order". How To: Randomly generate words in an Excel spreadsheet How To: Randomly generate letters in an Excel spreadsheet How To: Use the INDEX & MATCH functions in Microsoft Excel How To: Create a DV drop-down in Excel 07 without a table name Generating Random Groups in Excel. To write this formula, you can use the below steps: First, in a cell, enter the CHOOSE function. And in the first argument of the CHOOSE, which is index_num enter the RANDBETWEEN function. Now, in the RANDBETWEEN, enter “1” as the bottom and “4” as the top. So you have four groups to get the result Step 3: Thirdly, press Enter and you will see a winner’s name randomly selected by applying the above functions. Step 4: Furthermore, by pressing F9 on the keyboard, you can automatically generate more names. 2. Combining INDEX and MATCH Functions to Make an Electronic Raffle Draw in Excel. In our second method, we will combine the INDEX Using Excel's random name selection, you can easily select a winner from a list of participants. Here's an example of how it can be implemented: Create a column in Excel and label it "Participants." List all the participants' names in the column. Use the RAND() function in Excel to generate a random number for each participant. Excel random data: generate random numbers, texts, dates, times in Excel. =RANDBETWEEN (bottom*1000, top*1000)/1000. , and paste the following code in the. . Then, close the code and go back to the worksheet, in a blank cell, type this formula. : In the above formula, indicates the lower limit of the numbers, indicates the upper limit of the Wheel Decide Max of 100 names so 5 spins in total. Grp1 - Names 1 - 100 Grp2 - Names 101 - 200 Grp3 - Names 201 - 300 Grp4 - Names 301 - 350 Grp5 - Grp1 - Grp4 Winners Messages. 6,941. Dec 4, 2007. #4. I can't think of a way without creating a complex macro. using formulas you can use this approach. Keep sorting column B and C together until the value in D12 is 0. But make sure when you get the value to 0 that you copy and paste special values over what you have because each time the sheet changes the rand To generate a list of random text strings, you can use a formula based on INDEX, RANDARRAY, and TEXTJOIN. In the example shown, the formula in D5 is: =TEXTJOIN("",1,INDEX(chars,RANDARRAY(6,1,1,26,TRUE))) where chars is the named range B5:B30 containing the letters A-Z. As the formula is copied down the column, it generates a new 6-character text string on each line. Step 3: Copy & Paste the Random Values. Next, highlight the values in column B and click Ctrl + C. This will copy all of the values. Next, right click on cell C2 and choose Paste Values. Note that the values in column B may change once you do this, but don’t worry about this. Lastly, highlight the values in column C and drag them to replace A9VR5o.