New Excel Functions Coming!

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.
• SORT – sorts an array of values.
• SORTBY – sorts an array based on a corresponding array.
• SEQUENCE – generates a list of sequential numbers, such as 1, 2, 3, 4.
• SINGLE – accepts a range or array and returns a single value using implicit intersection.
• RANDARRAY – returns an array of random numbers between 0 and 1.

Leave a Reply

Your email address will not be published. Required fields are marked *

  • “..may I say it is rarer that I ever have gotten a personal reply from a CPE Site! Glad I have found your site.”

    - Tom

  • I wanted to compliment you on the Accounting Fraud – Recent Case Studies (AUCASEMC) course I just took. The ebook was fantastic! Concise, easy to understand, very well structured, and very interesting. Exactly the way I like it. Thank you for putting it together. I feel it took me enough time to be worth 2 CPEs, but it was fantastic nonetheless. Thank you.

    - Mark R.

  • You guys do a great job!  As a person in industry it can be really expensive to stay current and you have great options that are actually useful as well as cost effective!

    - Sue