• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

RANDARRAY in Excel

October 6, 2021 by Andrew Childress
RANDARRAY formula in Excel

Ever needed to generate a full array of random values in Excel? This is a great way to test out formulas. Here's how to use RANDARRAY in Microsoft Excel.

Ever needed to generate a full array of random values in Excel? This is a great way to test out formulas. Fortunately, Excel will do this automatically. You don’t have to input numbers yourself. Let’s learn how to use RANDARRAY in Microsoft Excel.

How to Use RANDARRAY in Excel

Imagine this scenario: you need to generate five rows and ten columns of random numerical values. Of course, you could make up 50 numbers, but this would take a while. And it wouldn’t be truly random. The best way to do this is to use Excel’s RANDARRAY function.

To use RANDARRAY, click into the first cell where you want to place your random array of values. For simplicity, we’ll use cell A1 in this example, but you can use any cell in your workbook.

Begin by typing an = sign, telling Excel that you’re inputting a formula into the selected cell. Then, insert the RANDARRAY function. So far, your formula reads:

=RANDARRAY(

RANDARRAY in Excel

Then, Excel asks for five inputs. First, you’ll need to input the number of rows, which is 5. Next, add the number of columns, which here is 10:

=RANDARRAY(5,10,

Then, Excel needs a minimum and maximum for your range of random values. All values in the array will fall between these two. We’ll use 1 and 500 here:

=RANDARRAY(5,10,1,500,

Finally, Excel needs to know if you want to have integer or decimal values. Integers, in essence, are round numbers. Decimal values may have one or more decimal places. To use round integer values, type TRUE. If you want decimals in your array, type FALSE. Here, we’ll use TRUE:

=RANDARRAY(5,10,1,500,TRUE)

RANDARRAY formula in Excel

When you’re finished keyboarding your formula, press Enter. Excel will return a random array comprising fifty unique values, all within your selected range.

How to use Randarray in Excel

As you can see, it’s easy to use RANDARRAY in Excel to generate a large volume of random values.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Average true range in ExcelCalculate ATR in Excel
Next Post:Formula for Income Tax CalculationIncome tax calculation in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top