OFFSET Function Dynamic Range Builder

Help me use OFFSET to create dynamic ranges:

**Use Case:**
- [ ] Dynamic chart data range
- [ ] Dynamic named range for lists
- [ ] Return value based on position
- [ ] Create rolling date range
- [ ] Dynamic sum/average range
- [ ] Dropdown list that grows

**Starting Point:**
- Base cell reference: [e.g., A1]
- Data structure: [describe how data is arranged]
- Data grows: [down / right / both directions]

**Dynamic Requirements:**
- What determines the range size: [e.g., number of non-empty cells]
- Starting offset from base: [rows down, columns right]
- Height: [fixed / dynamic - how determined]
- Width: [fixed / dynamic - how determined]

**Sample Data:**
[Describe or paste sample showing the data pattern]

**Combined With:**
- [ ] SUM, AVERAGE, COUNT
- [ ] Named range definition
- [ ] Chart data source
- [ ] Data validation source
- [ ] Other: [specify]

Please provide:
1. OFFSET formula for my scenario
2. COUNTA for dynamic sizing
3. Named range definition steps
4. Performance considerations
5. Alternative approaches (Tables, INDIRECT)
6. Troubleshooting common issues