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.

Learn how to use Excel’s dynamic array formulas to automate data pairing, save time, and unlock new insights in your analysis. Excel arrays ...

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.

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 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’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 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.