The RANDARRAY function in Google Sheets is useful when you need to generate an array of random numbers between 0 and 1.
You can specify the size of the array by specifying the number of rows and columns the array will contain.
Table of Contents
The rules for using the RANDARRAY
function in Google Sheets are as follows:
 The function requires two arguments: the number of rows and columns the array of random number needs
 The function then outputs an array of random numbers between 0 and 1 at a specified size
 Hitting the Enter key again will refresh the function and update the random numbers.
Let’s start with a quick usecase of this function.
For example, we would like to create a sample dataset. We know that we can use the RAND()
function to output a number between 0 and 1. However, if we need multiple columns filled with random values, we would have to use RAND
to generate each cell. Luckily, with the RANDARRAY
function, it becomes simple to generate a table of any size filled with random data.
We have now seen one possible usecase for the RANDARRAY
function. Let’s go deeper into how we can actually use it and later work on an actual sample spreadsheet.
The Anatomy of the RANDARRAY Function
The syntax of the RANDARRAY
function is as follows:
=ROUNDARRAY(rows, columns)
Let’s break apart this formula and understand what each of these terms means:

 = the equal sign is how we start any function in Google Sheets.
 RANDARRAY() is our
RANDARRAY
function. It generates an array of random numbers from 0 to 1.  rows refers to how many rows the array generated should contain.
 columns indicate how many columns the array generated should have
 If rows and columns are not specified,
RANDARRAY
returns a 1 x 1 sized grid.
A Real Example of Using RANDARRAY Function
Let’s take a look at an example of the RANDARRAY
function being used in a Google Sheets spreadsheet.
In the table above, we were able to use the RANDARRAY
function to fill up three columns with 25 rows each. The values of these cells will update if you reenter the formula.
To get the generated values, we just need to use the following formula in cell B2:
=RANDARRAY(25,3)
In this next example, we were able to fill another dataset with a differently sized array.
You can make your own copy of the spreadsheet above using the link I have attached below.
If you’re ready to try the RANDARRAY
function yourself in Google Sheets, let’s begin writing it ourselves!
How to Use RANDARRAY Function in Google Sheets
 To start using the
RANDARRAY
function, look for the location which will be the upperleft most cell in the array. In this case, we can write our formula in cell B2.
 Next, we just have to type the equal sign ‘=‘ to begin the function, followed by ‘RANDARRAY(‘.
 A tooltip box appears with info on the
RANDARRAY
function. We can click on the arrow on the toprighthand corner of the box to minimize it if necessary.
 Next, we need to specify the number of rows and columns the output array should have. In this case, we need 25 rows and 3 columns in our array.
Afterward, simply hit Enter on your keyboard to let the function evaluate.
 If you would like to keep the values from reupdating, you can copy the values over. To do this, first select the array and type Ctrl + C to copy the selected array. Next, you can type Ctrl + Shift + V to paste only the values of the copied array.
Alternatively, you may rightclick on the selection and select Paste Special > Values only from the menu. After doing so, your randomly generated values will no longer update after every refresh.
Frequently Asked Questions (FAQ)
 Can I use RANDARRAY to create an array of random integers between arbitrary values?
Though the output ofRANDARRAY
are values between 0 and one, we can use other functions to expand functionality.
In the example below, we’ve used an alternate formula to set a minimum and maximum range from which to choose numbers from. We’ve also used theINT
function to make sure that all of the numbers in the array are integers.
 Why does my formula return a #NUM! error?
The arguments of yourRANDARRAY
function must be a positive number. If the number is negative, the function will return a #NUM! error instead.
This stepbystep guide shows how easy it is to generate an array of random values from 0 to 1. Hopefully, you now have an idea of when to use the RANDARRAY
function after seeing multiple examples of it in action.
You can now use the RANDARRAY
functions in Google Sheets together with the various other Google Sheets formulas available to create great worksheets that solve your problems.
Are you always looking for new ways to use Google Sheets? You can find more helpful tips and tricks like this by subscribing to our newsletter!