New Functions in Excel
I just read a tweet from David Ringstrom and Joe McDaid about dynamic arrays and new Excel functions that are coming soon.
Truly amazing and a huge time saver for many. Check out this article which shows how each of the formulas works:
https://techcommunity.microsoft.com/t5/Excel-Blog/Preview-of-Dynamic-Arrays-in-Excel/ba-p/252944
It would seem that it will be a slow roll up, so keep your eyes open when you update.
Below are the complete set of functions that will be accompanying dynamic arrays.
• FILTER – filters an array of data based on criteria you define.
• UNIQUE – returns a list of unique values from a list or range.