Excel 2020: Understanding Array Constants
September 17, 2020 - by Bill Jelen
There are several dynamic array that get better with an array constant. Here is a simple way to understand them. A comma inside an array constant means to move to the next column. A semi-colon means to move to the next row. How do you remember which is which? The semi-colon on your keyboard is located near the Enter or Return key which also goes to the next row.
When you see an array constant with a mix of commas and semi-colons, remember that each semi-colon moves to a new row.
Title Photo: Dan Gold at Unsplash.com
This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.