Microsoft Excel: More Dynamic Arrays functions. By J. Carlton Collins, CPA. June 1, 2019. ... In addition to the new SORT function, you may also find the new FILTER and UNIQUE array functions useful.

The UNIQUE function can become even more powerful when combined with other Excel functions. Let’s do an example where we will use the UNIQUE function to create a list of unique customers, ... In cell ...

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

Master 15 essential Excel functions to boost productivity, ... For example, you can use it to ... Dynamic array functions transform how you work with multiple values simultaneously.

If you regularly work with data sets in Excel, you know how important it is to be able to quickly find the information you ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

Excel has SumIf and CountIf, but no AverageIf. However, with a little array magic, you can get Excel to average values, conditionally. Simply insert the following form as an array: =AVERAGE(IF ...

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.