In the following example, we have a column full of names of the people who participated in a lucky draw. We are now equipped with the knowledge of various functions which we will use. Pick a random name from a list in Google Sheets Column: The index of the column to be returned from within the reference range of cells.Row: The index of the row to be returned from within the reference range of cells.Reference: The range of cells where the values are located.The syntax of the INDEX function is as follows: =INDEX(reference, row, column) The INDEX function in Google Sheets is used to return the content of a cell by specified by row and column offset. Y: It is the ending range of the dataset.X: It is the starting range of the dataset.The syntax of the COUNTA function is as follows: =COUNTA(x:y) The COUNTA function in Google Sheets is used to count the number of cells in the selected range containing some value. The random number generated lies between low and high.High: It stands for the higher end of the range.Low: It stands for the lower end of the range.The syntax of the RANDBETWEEN function is as follows: =RANDBETWEEN(low, high)Ī brief description of the syntax is as follows: The RANDBETWEEN function in Google Sheets is a random number generating function. Understanding these functions will give you a better grasp of the tutorial. Pick a random name from a list in Google Sheetsīefore beginning the tutorial, we need to learn about a few functions that will be used in our formula.
#MULTIPLE RANDOM NAME PICKER HOW TO#
In this tutorial, we will learn the step-by-step process of how to pick a random name from a list in Google Sheets. In those cases knowing how to pick a random name from a list in Google Sheets might come in handy. There are instances where one has to pick up something randomly like a lucky draw or randomly assigning tasks to someone. Do you know how to pick a random name from a list in Google Sheets? It might seem to be tricky but the procedure is quite simple and easy to implement. Google Sheets offer a variety of tools that you can use to your advantage. Sample Google Sheets template with formula here. This will display a random name from a list of names in a column A (A4:A) in Google Sheets = INDEX(A4:A, RANDBETWEEN(1, COUNTA(A4:A) ) ) RANDBETWEEN – It generates a random number between 1 to nĬOUNTA – Counts number of cells (containing value) in the selected range =INDEX( reference, RANDBETWEEN(1, COUNTA(range) ) )
What it does – Generates a random name from a list of names in Google Sheets
0 kommentar(er)
