This means that Excel will dynamically create the appropriate sized array range when you press ENTER. The UNIQUE function will return an array, which will spill if it's the final result of a formula. In the examples above, the arrays for our UNIQUE formulas are range D2:D11, and D2:D17 respectively. An array can be thought of as a row or column of values, or a combination of rows and columns of values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |