Skip to content
Google Sheets

RANDARRAY function in Google Sheets

Generates an array of random numbers between 0 and 1. .

=RANDARRAY(rows, columns)

RANDARRAY syntax and parameters

Two arguments, two required.

  • rowsnumberRequired
  • columnsnumberRequired

RANDARRAY examples

Formulas you'll actually reuse.

  1. Ten random decimals from 0 up to 1 as a column:

    =RANDARRAY(10, 1)

  2. Whole numbers 1–100 — Sheets' RANDARRAY has no min/max, so scale it:

    =INT(RANDARRAY(10, 1) * 100) + 1

RANDARRAY in Excel

Same name — your formula ports as-is.

Try RANDARRAY in the playground

Edit the example — nothing to install.

Preloaded with the RANDARRAY formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.