DYNAMIC ARRAY FUNCTIONS

摘要

By far, the functions that seem to offer the most promise are SORT, SORTBY, FILTER, and UNIQUE. Most users are accustomed to using the sort icons or the filter tool when working with data, but there are times when you might want to sort a list but the calculations keep changing or when you don't want to leave it to the people using your worksheet to sort or filter the data properly. Being able to use a formula to do the same tasks can save time and ensure results appear as you want them to.