![]() ![]() NOTE: If you are curious to learn about these and other powerful Dynamic Array functions, check out my “ Excel 365 Functions for 2021 ” post. Spilled Ranges are created by using formulas that spill ex: UNIQUE, SORT, and SEQUENCE among others. The # at the end of the cell reference tells Excel to include ALL results from the Spill Range. We can modify the SORT formula to include ALL apps by adding a HASH ( #) symbol after the C1 cell reference. After all, we only gave it one cell to sort.īut we want to sort ALL the apps returned by the UNIQUE function. ![]() This produces a list consisting of one app. We place the following formula in cell E1… =SORT(C1) Now we want to sort the list that starts in cell C1. The results spill in the C1:C11 range of cells. We write the following Dynamic Array formula using the UNIQUE function to generate the unique list starting in cell C1. Suppose we have a list of apps in cells A1:A19 and we want to derive a unique list of apps. ![]() We use the # to instruct a formula’s cell reference to obtain all the entries produced by the Spill Range starting at a defined cell address. If you are not familiar with Spill Ranges, check out my video in the #SPILL! error message. The purpose of the HASH ( #) symbol is to refer to a Spill Range. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |