![]() UNIQUE() a list of values without any duplicates. For example, sort a list of class test results by student scores. ![]() SORTBY() sorts a table, range or array based on a one part of the source. Excel 2021/LTSC have the core dynamic array formulas: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY.Įxcel now has Dynamic Arrays – Windows, Mac and more …įILTER() filter a table, range or array to show only some items from the source. See all about Office 2021 for Windows & Mac plus The good and bad in Office LTSC Dynamic ArraysĪn array of values can be returned by using a single formula. In addition to the general Office 2021/LTSC features there are some useful additions to Excel 2021/LTSC including the dynamic array functions, improved XLookup()/XMatch() and Let() but sadly no Lambda().Īll these features are in Excel 2021 and Excel LTSC for both Windows and Mac in addition to the overall updates that apply to all the Office 2021/LTSC apps, see New and better features in Office 2021 and Office LTSC
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |