- Basic Information
- OFFSET function extracts data from specific cell range
- Function requires Ctrl+Shift+Enter unless using Office 365
- Syntax: =OFFSET(reference,rows,cols,[height],[width])
- Key Features
- Negative rows move up, negative cols move left
- Fractions automatically converted to integers
- Returns section of data with specified height and width
- Usage Methods
- Whole row extraction: moves down to specific value, right to next
- Whole column extraction: moves down to specific value, right to next
- Multiple rows/columns extraction: moves down to specific value, right to next
- Error Handling
- #VALUE error occurs with incorrect data types
- Text arguments display #VALUE error