Software for random selection of names

Available on PC. Description Picks a random name from a list of names. Show More. People also like. Countdown Pro Free. Interval Timer by Jalex Free. Interval Training Timer Free. Random - Number Generator Free.

Elite Interval Training Free. Randomizer App Free. What's new in this version Initial release. Features Pick a random name from a text-file Custom Background. Additional information Published by wertzui. Those eleven players will comprise one team, while the remaining will make up their opponents. If you'd like to cite this online randomizer resource and information as provided on the page, you can use the following citation: Georgiev G.

Calculators Converters Randomizers Articles Search. Random Name Picker Use this online name picker to draw a random name from a list of names, or to draw several names randomly out of a list.

List of names. Number of names to pick. Pick a Random Name. Share randomizer:. Generally, you'd use the RAND function to assign a random number to each cell, and then you pick a few cells by using an Index Rank formula. In our case, we copy the formula to four more cells C2:C6. Five random names are extracted without duplicates:. Like in the previous example, you use the INDEX function to extract a value from column A based on a random row coordinate.

In this case, it takes two different functions to get it:. A word of caution! As shown in the screenshot above, our Excel random selection contains only unique values. But theoretically, there is a slim chance of duplicates appearing in your sample. Personally, I've never got any duplicates during my tests, but in theory, such probability does exist. For the detailed explanation for the logic, please see Unique ranking in Excel.

In case your worksheet contains more than one column of data, you can select a random sample in this way: assign a random number to each row, sort those numbers, and select the required number of rows.

The detailed steps follow below. If you are not quite satisfied with how your table has been randomized, hit the sort button again to resort it. For the detailed instructions, please see How to randomly sort in Excel. Finally, select the required number of rows for your sample, copy them and paste to wherever you like. To have a closer look at the formulas discussed in this tutorial, you are welcome to download our sample workbook to Excel Random Selection.

Now that you know a handful of formulas to get a random sample in Excel, let's see how you can achieve the same result in a mouse click. With our Ultimate Suite installed in your Excel, here's what you do:. For example, this is how we can select 5 random rows from our sample data set:.