Excel Dynamic Arrays: 6 Examples of FILTER with Multiple Criteria

/in /by

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/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2