The function is simple point to the list of existing data. The UNIQUE function allows you to return a list of unique values from another list. Let’s look at some of these new functions. In Excel 2021, that same activity can be accomplished using this: In Excel 2019, the formula would look something like this: With these new functions, you’ll spend far less time trying to create complex, multi-layered functions to accomplish tasks.įor example, imagine trying to display all the employees in a list that belong to the “Sales” department. Many of these new functions are referred to as Dynamic Array functions.ĭynamic Array functions have many features that regular functions lack, such as the ability to “spill” many results from a single formula, as well as mitigate ( in many cases) the need for changing a relative reference to an absolute reference.įor a more in-depth explanation of these functions check out these links: Excel 365 Functions for 2021 Excel’s New LET Function Excel XLOOKUP Explained Excel FILTER Function Yearly Calendar in Excel with Formula If you are an Office 2016 user and are upgrading directly to Office 2021, check out these “new to you” functions.įor Office 2019 users upgrading to Office 2021, we have a new batch of functions that are about to change your Excel life forever. In Office 2019 we were introduced to new functions, such as: Every new release of Office brings with it new Excel functions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |