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.

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

After my recent post on using Office Scripts and cube functions to generate Excel reports from Power BI data, Meagan Longoria asked me this question on Twitter:. To which I can only reply: guilty as ...

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