OFFSET

Blog

How to Use the OFFSET Function in Excel

Quick Links A Basic Example of OFFSET Using OFFSET in the Real World Excel’s OFFSET function lets you create a reference that is—quite literally—offset from a starting point. It allows references to adjust dynamically to changes in your spreadsheet’s data and structure. The OFFSET Syntax Before we look at how it works in practice, let’s run through the syntax. The…