How to Randomly Select a Value from a List in Google Sheets
We are going to talk about how to randomize data using Google Sheets in the blog post that we are going to publish today. The randomization of data within a range and the randomization of data from a fixed list of values are the two scenarios that we will discuss.
There are two scenarios we will cover:
Scenario 1 : randomizing data within a range
Scenario 2: Randomizing data from a fixed list of values.
Scenario 1
The first thing we will do is investigate how to use the “rand” and “randbetween” functions to randomize data that falls within a certain range. Utilizing these functions, you are able to generate random numbers that fall between two values that you specify. For instance, if you want to randomize data between 0 and 100, you can use the formula “=randbetween(0,100)” to accomplish this. A random number between 0 and 100 will be generated as a result of this. You have the ability to adjust the range to meet your specific needs.
Scenario 2
Now we will move on to the second scenario, in which we will be attempting to randomize data from a predetermined list of possibilities. Consider the following scenario: we have a list of five distinct fruits, and we want to distribute them in a random fashion among a variety of individuals. Given the circumstances, the “randbetween” and “rand” functions will not be adequate by themselves. Utilizing the “index” and “randbetween” functions in conjunction with one another is an alternative. “=index(range of the list, randbetween(1, count(range of the list))” is the formula that would be used. Through the use of this formula, a fruit will be chosen at random from the list and then distributed.
Last but not least, let’s take into consideration a scenario in which we want to make sure that each fruit name is only assigned once. It is possible for us to accomplish this by utilizing the “unique” function in conjunction with the “count” function. “=index(unique(range of the list), randbetween(1, count(unique(range of the list)))” is the formula that would be used. The use of this formula guarantees that every fruit name is distinct and assigned in a random fashion.
