• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Working with Arrays

When you work with a range of cells, it might appear as though you're working with a single thing. In reality, however, Excel treats the range as a number of discrete units.

This is in contrast with the subject of this section: the array. An array is a group of cells or values that Excel treats as a unit. You create arrays either by running a function that returns an array result (such as DOCUMENTS()—see the section in this chapter titled “Functions That Use or Return Arrays”) or by entering an array formula, which is a single formula that either uses an array as an argument or enters its results in multiple cells.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint