Microsoft recently announced a handful of new Microsoft Excel Functions. And, they are blowing my mind!!
"Note: September 24, 2018: The FILTER function is one of several beta features, and currently only available to a portion of Office Insiders at this time. We'll continue to optimize these features over the next several months. When they're ready, we'll release them to all Office Insiders, and Office 365 subscribers." ~ Microsoft
For more information on the function, visit the Microsoft Site. See the bottom of the page for the functions.
For more information on Office Insider, visit Microsoft.
Download the exercise file: DynamicArrayFunctions-01