Formulas > =RANDARRAY()
How To Use RANDARRAY() Function in Google Sheets
Description
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.
Hints (2)
-
Remember to specify the number of rows and columns.
-
The numbers generated will be between 0 and 1.
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
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