Excel Guides

Picking Different Random Numbers from a Range in Excel

There are a few different ways that you can pick random numbers from a range in Excel. One way is to use the RANDBETWEEN function. This function will return a random number between the two numbers that you specify. For example, if you wanted to pick a random number between 1 and 10, you would use the following formula:

=RANDBETWEEN(1,10)

You can also use the RAND function to pick a random number from a range. The RAND function will return a random number between 0 and 1. You can then multiply this number by the number of values in the range that you want to select from. For example, if you wanted to pick a random number between 1 and 10, you would use the following formula:

=RAND()*10+1

You can also use the CHOOSE function to pick a random number from a range. The CHOOSE function takes an index value and returns the value from a list that corresponds to that index value. You can use the RANDBETWEEN function to generate a random index value, and then use that index value with the CHOOSE function to return a random value from your list. For example, if you had a list of numbers in cells A1 through A10, and you wanted to pick one at random, you could use the following formula:

=CHOOSE(RANDBETWEEN(1,10),A1:A10)

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.