You can generate a random number between 1 or 2 or from 1 to 3, 1 to 10, 1 to 50, 1 to 100, up to 1.000.000.000 and everything in between. Random Number PickerĪ Number Picker is used for many use cases, such as: You can adjust multiple settings in the to customize the numbers possible, amount of numbers and sequences, output of numbers, and more. You can generate a list with unique random numbers with no repeats and choose to exclude numbers. Use FALSE to return an array of decimal numbers between 20 and 80.Random Number Generator or Number Picker is a free online tool where you can pick a number or a sequence of random numbers. Note: the Boolean TRUE (fifth argument) tells the RANDARRAY function to return an array of integers. The RANDARRAY function below generates an array of integers, 10 rows by 1 column, between 20 and 80. Wow! This behavior in Excel 365/2021 is called spilling.Ģ. Note: this dynamic array function, entered into cell A1, fills multiple cells.

The array below consists of 5 rows and 2 columns.

By default, the RANDARRAY function generates random decimal numbers between 0 and 1. If you have Excel 365 or Excel 2021, you can use the magic RANDARRAY function.ġ. If you want to generate random decimal numbers between 50 and 75, modify the RAND function as follows: Type RANDBETWEEN(50,75) and press Enter.ģ. The RANDBETWEEN function generates a random whole number between two boundaries.Ģ. This cell holds a value now and not the RAND function. Select cell C1 and look at the formula bar. If you don't want this, simply copy the random numbers and paste them as values.ĥ. That is because random numbers change every time a cell on the sheet is calculated.Ĥ. To generate a list of random numbers, select cell A1, click on the lower right corner of cell A1 and drag it down. The RAND function generates a random decimal number between 0 and 1.Ģ. Excel has two very useful functions when it comes to generating random numbers.

Generate list of random numbers