SORT is one of several new functions that take advantage of Excel’s new Dynamic Arrays functionality, which was recently released as a beta feature to some Office Insiders (see the February 2019 Tech ...

Other array-based functions include SORTBY and RANDARRAY. The SORTBY function works like the SORT function, except it sorts data according to data contained in another array. For example, you might ...

You can also try using Excel’s built-in Evaluate Formula feature to review array formulas. Here’s how you can do that: First, select the problematic cell and look into its formula bar.

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

Among all the exciting announcements made at Ignite last week, one you may have missed (even in all the Excel-related announcements here) was that dynamic arrays have finally reached GA. Ever since ...

This function is available only in Microsoft 365, Excel for the Web, Excel 2021 and Excel for iPad, iPhone, and Android tablets and phones. For your convenience, you can download the demonstration ...

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