![]() Any optional argument that is not set defaults to 1.The resulting array can be one-dimensional or two-dimensional, depending on how you configure the rows and columns arguments.So, be sure you have enough empty cells down and to the right of the cell where you enter the formula, otherwise a #SPILL error will occur. If the array of sequential numbers is the final result, Excel outputs all the numbers automatically in a so-called spill range.In Excel 2019, Excel 2016 and earlier versions, it does not work since those versions do not support dynamic arrays. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |