Table of Contents
To select a random value from a list using Google Sheets, you can use the “RAND” function. Simply, enter “=RAND()” in a cell next to the list and drag it down to generate a random number for each item in the list. Then, use the “INDEX” function to refer to the list and the generated random number to select a random value. This will allow you to efficiently and accurately select a random value from a list using Google Sheets.
Google Sheets: Select a Random Value From a List
You can use the following formula to select a random value from a list in Google Sheets:
=INDEX(A2:A16,RANDBETWEEN(1,COUNTA(A2:A16)))
This particular formula selects a random value from the range A2:A16.
The following example shows how to use this formula in practice.
Example: Select Random Value from List in Google Sheets
Suppose we have the following list of values in Google Sheets:
We can type the following formula into cell C2 to select a random value from the range A2:A16:
=INDEX(A2:A16,RANDBETWEEN(1,COUNTA(A2:A16)))
The following screenshot shows how to use this syntax in practice:
We can see that the formula randomly selected 26 from the list of values in column A.
If you click on cell C2 and click Ctrl+C, then click Ctrl+V to paste the same formula back into cell C2, a new value will be randomly selected from the list:
We can see that the formula randomly selected 33 from the list of values this time.
Note: You can find the complete documentation for the RANDBETWEEN function in Google Sheets .
Additional Resources
Cite this article
stats writer (2024). How can I select a random value from a list using Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-select-a-random-value-from-a-list-using-google-sheets/
stats writer. "How can I select a random value from a list using Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-select-a-random-value-from-a-list-using-google-sheets/.
stats writer. "How can I select a random value from a list using Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-select-a-random-value-from-a-list-using-google-sheets/.
stats writer (2024) 'How can I select a random value from a list using Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-select-a-random-value-from-a-list-using-google-sheets/.
[1] stats writer, "How can I select a random value from a list using Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I select a random value from a list using Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.