• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. Excel's Data Management Features > Locating Data with OFFSET

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.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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