How to Use RANDARRAY() in Google Sheets

Description

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

How To Actually Use RANDARRAY() in Sheets

RANDARRAY(rows, columns)

Try RANDARRAY yourself

Use the RANDARRAY function to generate a 5x3 array of random numbers between 0 and 1 in the range A1:C5.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for RANDARRAY(). Click through to watch.

Watch more tutorials

Hold a Giveaway Raffle in a Google Sheet

Get a random winner from a list of names. Also great to randomize tasks ...

Unlock these tutorials

Learn more about the RANDARRAY() formula:

Generate a RANDARRAY() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses RANDARRAY(). 2 free AI generations, no signup. Members get unlimited use.

Generate a RANDARRAY() formula

How to Use RANDARRAY() in Google Sheets

Try RANDARRAY yourself

More related tutorials

Hold a Giveaway Raffle in a Google Sheet