Unlike CC we can get the length of the array using the length member. An array with n elements is indexed from 0 to n-1. Arrays What Are They And Why Do We Use Them Shelley Gray Or various kinds of the above such as. . A large group of things or people especially one that is attractive or causes admiration or has. An array formula one that spans multiple cells can do calculations on rows and columns of cells where you might otherwise need to use several formulas. To insert values to it we can use an array literal - place the values in a comma. This makes it easier to calculate the position of each element by simply adding an offset to a base value ie the memory location of the first element of the array generally denoted by the name of the array. Arrayed the whole regiment on the parade ground. For example you can count the number of characters that are contained in a range of cells sum only numbers that meet certain condi