How to randomize names in excel to select / specify random sampling or split groups with excel formulas.
In the previous tutorial we learned about excel how to randomize a sequence of numbers in excel by utilizing excel Rand function. In this section we continue by learning about how to randomize names from the list that has been provided for us to choose at random.
This kind of case, for example, we find when we want to divide the group with excel, divide the class with excel or select a research sample at random (random sampling) with excel formula.
Please note the following picture :
From the screenshot above we want to choose randomly from a list of existing names and the results will appear in the yellow cell (C2).
So, what excel formula can we use to solve the above problem?
In the previous case, we used excel RAND function, in this case we take advantage of RANDBETWEEN excel function.
A more detailed explanation of the two functions provided by microsoft excel can be learned on the following page :
Formulas Randomize Names In Excel
To randomize the names on the excel worksheet above write the following excel formula in cell C2:
How Excel Random Sampling Formula Works
In the excel formula above excel INDEX formula used to retrieve data from an excel range in accordance with the index number or sequence number that we specify.
In general, the syntax of the INDEX function in microsoft excel is as follows:
INDEX(reference; row_num; [column_num]; [area_num])
In the excel name randomization formula above, argument [column_num] and [area_num] we ignore (not filled/used), because it is not required and is optional.
Reference Index used in the index function above is range A2:A11 which is the range of data from the list or list of names that we will randomize. While the argument row_num we fill it with the following excel formula:
RANDBETWEEN formula it is he who will determine the random or random name that will be generated.
In general, the syntax of the RANDBETWEEN function in microsoft excel formulas is as follows:
The smallest number we fill with the number 1, while the largest number we fill with the formula:
Formula COUNTA used to calculate the amount of data or list of names that we will random.
In the case above excel formula COUNTA(A2:A11) you can also change this by using the constant number 10 which is the number of data lists that we will randomize. so that the random sample formula used is:
In conclusion, the excel formula above Randbetween will generate a random number between 1-10 where the result of this random number will be used by the index function to determine which data from a given index reference will be generated.
The last after the excel formula above you have successfully written and does not produce an error then to do the next name randomization you just need to press the button F9 on the keyboard or by selecting the menu Calculate Now which is on The Formulas Tab--Group Calculation to perform randomization repeatedly as needed.
Our discussion about how to randomize names in excel here. Before moving on, please SHARE this excel tutorial by utilizing the share button that is available below.
Thanks for visit my blog!