‍

In this article, you will learn how to use the RANDARRAY formula in Google Sheets.

‍

‍

What is the RANDARRAY function in Google Sheets?

‍

The RANDARRAY function in Google Sheets is a function that generates a random array of numbers between 0 and 1, which you can use to populate a range of cells in a spreadsheet with random values.

‍

   Save hours formatting your next financial spreadsheet!

   100+ templates, all free to use.

   Free Spreadsheet Templates

‍

‍

How do I use the RANDARRAY function in Google Sheets?

‍

Here is the syntax for the RANDARRAY function:

=RANDARRAY([rows], [columns])

=RANDARRAY([rows], [columns])

=RANDARRAY([rows], [columns])

=RANDARRAY([rows], [columns])

‍

rows: The number of rows in the array.

‍

columns: The number of columns in the array.

‍

Note that the two parameters are optional, so you can leave them blank. In that case, the formula shows a 1x1-sized array, a single random value.

‍

For example, if you wanted to generate a 2x2 array of random values between 0 and 1, you could use the following formula:

=RANDARRAY(2, 2)

=RANDARRAY(2, 2)

=RANDARRAY(2, 2)

=RANDARRAY(2, 2)

‍

This would generate a 2x2 array of random values between 0 and 1, like this:

‍

‍

   Turn Quickbooks Online data into a Google Sheets dashboard

    100+ templates, update automatically, totally secure!

   Book a Demo