Excel Array Construction
This article will talk about how to create one-dimensional array or two-dimensional array by using some functions in Excel. When using array formulas in Excel, we often use functions to construct arrays. Generate Array with ROW or COLUMN Functions Array formulas often need to use “natural number” as parameters of the function, such as the… read more »