Locating Data with OFFSET

The OFFSET function returns a reference to a cell, or to a range of cells, and it displays their contents. Figure 2.2 has a basic example of OFFSET.

Figure 2.2. OFFSET is one good way to rearrange data from a table.
[View full size image]

Understanding the Basis Cell

OFFSET needs a cell reference to use as a basis. You will also tell OFFSET how many rows and how many columns to shift, or offset, but first it needs to know which cell to shift from.

The whole idea behind the OFFSET function is that you want the address of a range of cells that are near to some other cell. For example, you might want to use the address of ...

Get Managing Data with Microsoft® Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial