Microsoft Excel — Hard
Key points
- TOROW and TOCOL handle 2D to 1D array conversion
- They ignore blanks and errors during conversion
- Dynamic array functions often require this conversion
- UNIQUE and lookup arrays expect 1D input
Ready to go further?
Related questions