---
title: Using Basic Arrays in Excel - U.S. Computer Connection
description: An array is a type of formula that can perform multiple calculations on one or more items in an array . You can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results or a single […]
---

[Blog - U.S. Computer Connection](https://blog.uscomputer.com)

# [Using Basic Arrays in Excel - U.S. Computer Connection](https://blog.uscomputer.com/using-basic-arrays-in-excel-2)

 Written by [Garry Feldman](https://blog.uscomputer.com/author/garry-feldman) | Jun 20, 2019 8:44:01 AM

<https://youtu.be/OGX_HyS3gUg>

An array is a type of formula that can perform multiple calculations on one or more items in an array . You can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results or a single result. Advantages of arrays are:

– Consistency & Accuracy: If you click in any of the cells with an array formula, you see the same formula  
 – Save time by calculating many formulas at once .  
 – Safety You cannot overwrite a component of a multi-cell array formula, since it applies to all the cells in the array.  
 – Smaller file sizes You can often use a single array formula instead of several intermediate formulas, saving time & storage space.

[View full post](https://blog.uscomputer.com/using-basic-arrays-in-excel-2)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Garry Feldman"
  },
  "dateModified" : "2022-10-17T16:00:42.006Z",
  "datePublished" : "2019-06-20T08:44:01Z",
  "headline" : "Using Basic Arrays in Excel",
  "image" : {
    "@type" : "ImageObject",
    "height" : 225,
    "url" : "https://22620873.fs1.hubspotusercontent-na1.net/hubfs/22620873/Imported_Blog_Media/WebinarReplay-Oct-17-2022-03-59-11-76-PM.jpg",
    "width" : 320
  },
  "mainEntityOfPage" : "https://blog.uscomputer.com/using-basic-arrays-in-excel-2",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "Blog"
  }
}
```