Excel Dynamic Arrays: 6 Examples of FILTER with Multiple Criteria
Excel's new Dynamic Array functions are trippy! They require a whole new way of thinking.
In this video I play with the FILTER function just to see what it does. You'll see 6 examples of complex, multi-conditional, multiple column formulas.
For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/ins...
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...
My old blog: http://datascopic.net/blog-2-2