Microsoft Excel — Hard
Key points
- Distinguishes between single-cell and spill range references
- Enables referencing dynamic array results in other formulas
- Requires dynamic array formulas to produce multiple values
- Used with dynamic array formulas in Excel 365
Ready to go further?
Related questions