RANDARRAY

Explanation

RANDARRAY is a function that generates an array of random numbers.

It is part of the Excel Dynamic Array Formulas. This is a group of formulas which allows the user to type a formula in a single cell, and receive a result in a whole range.

It is important to note that as of December 2019, this function is not yet available on Excel desktop, and is only available on Excel Online and for Office Insiders. But why wait when you can already practice it? 🙂

Example

Syntax

=RANDARRAY([rows],[columns],[min],[max],[integer])

[rows] – How many rows should be in the range of random numbers?

[columns] – How many columns should be in the range of random numbers?

[min] – What is the minimum random number?

[max] – What is the maximum random number?

[integer] – Should the numbers be an integer or decimal? 0 or FALSE means that numbers can be decimal, while 1 or TRUE means numbers will have to be integers. If left empty, the default will be FALSE – meaning that the function will return random decimal values.

 

We can see that all arguments in this function are optional (because of the square brackets).

Leaving [rows] / [columns] empty will result in a range with 1 row / 1 column only.

Leaving [min] / [max] empty will result in 0 for min and 1 for max.

And as mentioned before, leaving [integer] empty will result in random decimal numbers.

Practice RANDARRAY function

Example #1 – Creating an array of integer numbers

Example #2 – Creating an array of decimal numbers