How to Use RANDARRAY in Excel (in Under 5 Minutes!)
The Excel RANDARRAY function is a powerful, dynamic array function that combines the features of the RAND and RANDBETWEEN functions, then adds even more tricks!
So if you use Microsoft 365 or Excel 2021, RANDARRAY makes generating random data sets in Excel a whole lot easier!
With RANDARRAY, you can:
-Use it like the RAND function to generate a single random number
-Set the quantity of random numbers to generate by setting the number of rows and columns you want
-Establish minimum and maximum limits to the random numbers generated - as you would with RANDBETWEEN
-Set whether you want to see your results as decimals or as integers
Click here to read our step-by-step article on this: https://yacostasolutions.com/randarra...
If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: https://yacostasolutions.com/newsletter/
In this step-by-step tutorial, we'll go over:
00:00 - Intro +what is RANDARRAY
00:48 - How to Generate a Single Random Number
01:08 - How to Set the Quantity of Random Numbers Generated with the Rows + Columns Arguments
02:51 - How to Set Minimum and Maximum Limits for Your RANDARRAY Results
03:43 - How to Set Your RANDARRAY Results to Display as Either Integers or Decimals
*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: https://amzn.to/302tWl4
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: https://amzn.to/40uC4HL
Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊
To catch our Excel tutorials as they come out, subscribe to this channel by clicking: goo.gl/t7VrWZ
Thanks!
*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!
#YAcostaTutorials
